[ic] st=db

Ed LaFrance edl at newmediaems.com
Wed Nov 12 13:17:10 EST 2003

At 12:13 PM 11/12/2003 -0800, you wrote:
>Why wouldn't you want every loop search to use st=db to search the database
>instead of the txt source file?  The txt file is only up to date when it has
>just been exported from the db file, right?  It seems like leaving st=db out
>of a loop search would send you searching through old data most of the time.
>I'm noticing that happening now that I've upgraded to mySQL, but maybe it
>was happening before too.
>- Grant

Ironically, you may get better performance out of those text-file searches 
now, since in most cases interchange applies a [loop search..] to SQL by 
doing a 'select * from table' to grab a copy of the entire table contents, 
essentially importing it and scanning it locally. This is not very 
efficient to say the least, and can kill your catalog's performance with 
large tables.

The best answer at this time is to start replacing interchange-type 
searches with SQL passed via the [query] tag; well-written queries and 
judicious indexing of SQL tables will give you impressive performance 
gains. Rewriting the code for the keyword search box and the standard 
foundation catalog results pages, sidebar links code (bar_link routine), 
components which utilize search code, etc., is also well worth the effort 
once you have comitted to SQL, IMHO.

- Ed L.


New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax

More information about the interchange-users mailing list