jfguilmard
IS-IT--Management
Hi,
i'm about to build a DB which should be around 200 000 rows. Each line would be 2 fields: user_name, status
So i'm wondering about performances:
Is it better to build 26 tables: first one user beginning by "a" second one by "b" etc, or one big table with everyone? I guess the first solution will increase the speed? What about the cpu? the memory?
The queries will be mostly select, and some update to change the status field...
Thx for your advice on this matter
Jeff
i'm about to build a DB which should be around 200 000 rows. Each line would be 2 fields: user_name, status
So i'm wondering about performances:
Is it better to build 26 tables: first one user beginning by "a" second one by "b" etc, or one big table with everyone? I guess the first solution will increase the speed? What about the cpu? the memory?
The queries will be mostly select, and some update to change the status field...
Thx for your advice on this matter
Jeff