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. James On 4/19/07, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > > > > You shouldn't be embedding all those towns in a static format. They should > be stored in the database and you should be querying against them. Storing > all that data in a static format is going to be a maintenance nightmare. > > I'm also hoping you're not trying to return the entire 694KB on every > request. You should only be returning items that match your subset of > data. > > -Dan > > > > >
