Hi guys,
I just need a suggestion - I have one table, which has about 2 million records in it, when I do a search against it, even when trying to be very specific, it takes a very long time to pull data out of it (I'd say 1-3 minutes).
The table has a column with years in it (e.g. 2001, 2000, 1999) there are over 300.000.00 records for each year. Also, it has a column with "types" in it - for example "Male, Female".
Here is what I'm thinking of doing, but need your suggestions...
1. if I divide the table by year, into several tables (1 year and data with this year for 1 table)
2. then create another table with separate types in it - 1 for male, 1 for female
3. And index it all
Then use joins to join "type" with "year" will this speed up the search??
Thanks!
I just need a suggestion - I have one table, which has about 2 million records in it, when I do a search against it, even when trying to be very specific, it takes a very long time to pull data out of it (I'd say 1-3 minutes).
The table has a column with years in it (e.g. 2001, 2000, 1999) there are over 300.000.00 records for each year. Also, it has a column with "types" in it - for example "Male, Female".
Here is what I'm thinking of doing, but need your suggestions...
1. if I divide the table by year, into several tables (1 year and data with this year for 1 table)
2. then create another table with separate types in it - 1 for male, 1 for female
3. And index it all
Then use joins to join "type" with "year" will this speed up the search??
Thanks!