August 27, 2003 at 9:51 am
We have a real estate system in development. We need the listing page to be lightening fast. Currently it is around the 1.5 second mark. Alot of the execution plan is Hash Match. Can I make this faster?
August 27, 2003 at 10:22 am
Tough one without more information. Indexing differently, reducing the set sizes byu perhaps moving data from tables might help. Indexed views might work depending on the update levels.
Of course many places gain speed by caching things. Trading off age of the data for speed.
Steve Jones
August 27, 2003 at 10:43 am
If you are consuming most of your time (out of your 1.5 sec) in retrieving the data from a specific table (or couple), you could think about to pinning table in Memory using DBCC PINTABLE. This way, table will in Memory all the time. But you might also want to check memory size with respect to volume of the data in that table. Somestimes this is very dangerous. You can check Books Online for more details.
As Steve Jones mentioned, there lot many places where you can increase performance.
.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply