mayamanako
Technical User
Hi guys,
Sorry guys if this is not the appropriate forum for this question. Im just not sure where should this belong. I just thought that it could also have something to do with the SQL.
I have an auto suggest dropdown which was a bit faster intially. Now that the keywords are a couple of thousands, the suggest dropdown is becoming slow and it takes about 3 seconds before it shows.
I am using .asp, sql server2000 using the patindex to search for the keywords.
Any idea to make it a bit faster?
Thanks.
Sorry guys if this is not the appropriate forum for this question. Im just not sure where should this belong. I just thought that it could also have something to do with the SQL.
I have an auto suggest dropdown which was a bit faster intially. Now that the keywords are a couple of thousands, the suggest dropdown is becoming slow and it takes about 3 seconds before it shows.
I am using .asp, sql server2000 using the patindex to search for the keywords.
Any idea to make it a bit faster?
Thanks.