George L
|
Posted: 05/18/2004, 4:55 PM |
|
Hi,
(MySql/PHP)
I have one page with menu, path component, grid for displaying results from path component & grid for displaying result from a search form. On the search results grid I must have links - they should lead to the first grid with product details and trigger a Path component.
In order to make Path component to display the complete path I need 3 params from 2 tables: groupid, id & name from prodlist & groupings tables.
Here is how Datasource SQL for search results grid looks like:
SELECT sku, groupid, prodlist.description AS prodlist_description, id, name
FROM prodlist INNER JOIN groupings ON
prodlist.groupid = groupings.name
WHERE prodlist.sku LIKE '%{search}%'
OR prodlist.description LIKE '%{search}%'
ORDER BY prodlist.groupid
Everything works BUT very, very slow ~ 5 seconds for loading a page.
On the other hand it works very fast if I take away one table and make Datasource SQL like this:
SELECT *
FROM prodlist
WHERE prodlist.sku LIKE '%{search}%'
OR prodlist.description LIKE '%{search}%'
ORDER BY prodlist.groupid
But in this case I can't get Params for Path component though.
Any help would be appreciated.
Thank you.
|
|
|
|