Posted on 2008-01-30
I have a big problem......I have 4 sql tables that are fairly large let say 10-12 GB each. Every month I dump previous month data and add new month data. Here is the situation user needs to access certain data from these big tables for example users looking for data in the field1 where the value is 123. I have been creating sub tables for the users. But now its becoming problem managing them. I tried creating views but it was taking for ever. Also the users use MS Access with sql link tables to access the data. is there a better way of doing this so I dont have to create sub tables. Also there is no index in tables cuz every month I drop old month data and add new month data. I do understand that by indexing it improves performance but we are talking millions of records here in a table. Please help me out here to resolve this problem. Also each table contains 110 coulumn.