James, >Hi Dan as you can tell I am still a bit new to all this programming thing I >have limited the number of results returned to 10 and set the number of >char needed before a query is made is set to 2, as I also need users to be >able to search by the postcode eg " CHATSWOOD WEST NSW 2067" the user >might start typing in ch...... or enter 20... > >The form returns data very fast and I should not have to update the list >very much do you still think I should use SQL i was thinking it would just >slow down the process of searching.
Provided you're using a real DB platform (MSSQL, Oracle or even mySql) then querying the database for this type of data should be operation that's not even really noticeable. With any decent DB server, if you enabled debugging, you'd probably see 0-10ms response times. My guess is initiating the array and searching the array is going to be much slower than using SQL. They both might be fast enough not to notice, but at least if the data's in your DB there's a lot more you can do with it. -Dan
