October 6, 2004 at 9:16 am
I am running SQL Server 7 (SP3a) and have a very large table in the database. We were discussing possibly splitting the table in two to perhaps increase performance and slow down some lag time.
What would be the bext way to go about this....The table I'm talking about contains documents and we'd like to split it up by date.
Has anyone seen that this increases performance at all?
October 6, 2004 at 9:51 am
Hello,
The general recommendations that will increase performance are
1. Split the table and put 2 new tables on different filegroups on different drives.
2. If the old documents are not accessed often then putting them into the separate table will increase performance for sure.
3. Put a big table and its non-clustered indexes on different filegroups on different drives.
4. Did you create indexes at all? Did you create too many?
5. How do you store documents? Are those documents themselves or pathes to the documents on the folder?
Yelena
Regards,Yelena Varsha
October 6, 2004 at 11:07 am
Just to add ont o what yelena mentioned. You can split your tables as much as you want and then create a view on top of all your small tables if you ever have to access the data for say reporting purpose.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply