Large table search performance
I have a large table with 300,000 rows and it will grow in the future The table contains member profile details and it has many columns (about 70) The stored procedure that do the search use many columns to search the results That why the ‘Where’ is very long and the all operation take to many time, some time I get Time out exception form the SQL server. I’ll be happy to get some ideas how to do this search. I think maybe to divide the table to many tables by State. Something interesting is that the operation takes long time for the first search and then the second and the third are much faster, and after a few min that I’m not do anything again the first time is very slow
I have a large table with 300,000 rows and it will grow in the future The table contains member profile details and it has many columns (about 70) The stored procedure that do the search use many columns to search the results That why the ‘Where’ is very long and the all operation take to many time, some time I get Time out exception form the SQL server. I’ll be happy to get some ideas how to do this search. I think maybe to divide the table to many tables by State. Something interesting is that the operation takes long time for the first search and then the second and the third are much faster, and after a few min that I’m not do anything again the first time is very slow
