Optimization in Query

[Panchal Hardik]

Hello, I have two table one has more than 10,10,000 rows and another table has more than 3,00,000 rows. First table represent the inventory and second table represent the unique items. if some one search on the any product i am using full text search & Inner join to find out the resul. currently this query working but when the data in the invetory increase and number of user on server than server resources reaches 100% which result in the slow down the site. So please any help me for any suggestion for optimize my query. Thanks

[Pete OHanlon]

Try these articles: Performance Part 1[^] and Performance Part 2[^].

Deja View - the feeling that you've seen this post before.