Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sduffy77
Starting Member
18 Posts |
 Posted - 2008-12-09 : 11:10:12
|
| Hello All, I currently have a huge stored procedure that does searches through our inventory table. The inventory table has just over 1mil rows and is updated daily.The search can take up to 40 different filters and incorporates logical paging so it's passing in row index, page size, sort by, and direction.I am currently passing in all the filter parameters, building a where clause, and running the query using dynamic sql by calling sp_executesql. Is there a better solution for this as this seems to be extremely processor intensive. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 11:16:55
|
| you can try to implement boolean search condition to replace dynamic sql string. for more details give a sample query |
 |
|
|
|
|
|
Search Database Best Practices