Grant wrote: > Sorry for replying to myself. Does anyone know which one of these is > generally faster than the other? > > 1. > [loop list="sku1 sku2 sku3 ..."] > [loop-data products title] > [/loop] > > 2. (with proper mysql indexes) > [loop search="search goes here"] > [loop-param title] > [/loop] I'm not sure... try [benchmark] and see :) My inclination is that IC will perform three queries for the first, and one for the second, but I'm not that intimate with the DB code. > Is this the proper way to set up mysql indexes in products.mysql: > > Database products COLUMN_DEF "title=char(100), INDEX(title(100))" AFAIK it doesn't matter what you have in the IC sql definition - MySQL is going to use the index if it can, if you've created the right index. There's a lot to how indexes are used - if you are making a simple equality match on one field, then the difference of adding an index is pretty significant. One thing to look for are calling [data] from other tables inside the query. You can often achieve this nicely with a JOIN. I'm just stabbing in the dark here - feel free to post something more specific if you like. GL, JT -- Web: http://www.signless.com E-Mail: suppressed Cell: (541) 543-4888 Skype: jt.justman _______________________________________________ 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.