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.
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
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