[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ic] large field and keyword searching best practices?


March 25, 2003

Hello group.  Could someone provide me with some information on
searching multiple fields particularly where one or more of the fields
in different tables where some field are extremely large and are of data
type, "text" in the database.

I could certainly see building indexed search words that link to product
into a separate table at an off-peak time that I can than build a
"rated" keyword search against, but this is just a guess, and it also
seems like I would have millions of records!

The dbm I am using is postgresql.  The system IC is running on is a 1.1
Ghz PIII with 1 GB of RAM, no RAID implementation (single SCSI 7200 rpm
drive).

Any advice would be appreciated.

Thank you for your time.

-------
Andrew

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.