• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Slow performance-Full text search

 
Ranch Hand
Posts: 1907
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
For reporting purpose I am displaying some records in browser from one database(MSSQL) table based on some criteria.The fields which I am comparing contain 12-13 character strings.In select query I am comparing the values of these fields.If the total records are less say 100000,it works perfectly but total records are more than 500000(which will be the case in 'production'),getting the results take 'long' like 18-19 secods time.
Query is very simple,Supoose table T and attributes are A1.....An.and A1 and A2 are attributes which I am using in select query:

Any idea on how to improve the performance?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Any idea on how to improve the performance?


Have you tried running the query in your database's profiling tool? Most DBs will suggest if indices are needed to improve performance, which is probably the case in this instance.

As an aside, if you have a distinct requirement to provide free text searching over your data it makes sense not to implement this in the database itself, but with a third party IR tool like Lucene.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!