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 |
|
kaus
Posting Yak Master
179 Posts |
 Posted - 2001-08-08 : 18:20:58
|
| I have an app that hits SQL 2000 from ASP page -- Its a 3 table join with 2 where clause paramters. Table 1 has approx 500,000 recs, T2 approx 10,000, T3 approx 2,0000. Joins and where clause params are all indexed. The where clause params are an in () clause of numeric field -- can be from 1 to 500 in the list and a date between clause -- between 1900 and present. The result can take anywhere from almost instantaneous to maybe 35 seconds -- Id like to improve the performance.I've tried 1) indexes on where clause and joins2) using Select Top -- then the user can choose to download all the results if they wantI'm wondering if a) stored procedure would help -- It would have to be dynamic SQL so I dont know how much more performance I'd getb) create temp table of the codes in the in () clausec) I cant really reduce the number of codes selectedWould appreciate any thoughts -- When I made this thing I knew just enough to get it working -- would be nice to have it faster -- It doesnt experience a high volume of use by any meansThanks |
|
|
|
|
|
Speed Up App