ft outer join na_itemkeyword_tbl k on i.item_id=k.item_id
left outer join na_itemdesc_tbl d on i.item_id=d.item_id
Regards,
Harpreet Kaur
Crispin Corporation
(919) 367-7911
(919) 791-9886 (Cell)
-Original Message-
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02
na_itemdesc_tbl d on i.item_id=d.item_id
Regards,
Harpreet Kaur
Crispin Corporation
(919) 367-7911
(919) 791-9886 (Cell)
-----Original Message-----
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 1:47 AM
To: Harpreet; 'php windows'
Subject: RE: [PHP-WIN] Se
: Harpreet [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 10:22 PM
To: php windows
Subject: [PHP-WIN] Search results
I have a search page on my web application that searches a database with
1000's of rows. The search results are returned in like 45-50 seconds.
If the user goes to an
I think before trying this you should take a closer look at your
database and query structure to determine what is causing a 45 to 50
second delay in getting the results. It may be that you just need to
optimize a bit. For instance, if you have a large number of columns and
are using select *,
I have a search page on my web application that searches a database with
1000's of rows. The search results are returned in like 45-50 seconds.
If the user goes to another page and then returns to the same page again
it takes the same amount of time.
Is there a way to use session variables to rem
