Hi The data structure looks like fine to me. The table I am querying contains 70,000 records and the fields because that is what the customer needs. It is basically vehicle information going back to 2006, customer needs this info because they offer lifetime warranty on the parts. The searches are basically to find out the history of given customer and/or part.
I already give the customer the option to limit the search to either the vehicle registration or part number or client name and this is always quick. I reckon they are just being a little lazy so instead of choosing the search from a combobox they just leave it set at any field. I have to deliver what the customer wants otherwise I am not going to be in business very long..! -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of AndyHC Sent: 10 February 2013 15:46 To: [email protected] Subject: Re: SQL Server optimisation On 10/02/2013 21:09, Graham Brown wrote: looks like you need to do a major redesign of your data structure! AndyD > Hi all > > I'm trying to work out whether it is possible to optimise a query on > approx. 70,000 records. > The problem is that the customer wants to do an "All fields" search so > I have something like: - > > nH=sqlstringconnect(gcConnString) > cSQL="select f_rn from tablename where field1 like '%ABC%' or field2 > like '%ABC%' or field3 like '%ABC%' ...." > sqlexec(nH,cSQL,"curs") > ... > > Does anyone know of any possible solutions to this one please? > > .... > > > Regards > Graham > > > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
