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
Hi!
I agree to Armando about the optimasation about the search-query. If you show
some bit of code (it may be useful only with the actual query used to search),
we maybe can help you!
Best regards
/Gustav Wiberg
HMN Konsult (Sweden)
http://www.hmn.se/
-Original Message-
From: Harpre
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 *,
