October 2nd, 2000, 04:57 AM
|
|
Junior Member
|
|
Join Date: Jan 2000
Location: Calcutta, West Bengal, India
Posts: 25
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
If I have a huge database and search on a fields (category) alphabetic wise, will it be faster than having 26 tables on basis of category A, category B, ..... Category Z and searching a single table by checking for 1st caharacter of category
i.e if category = 'development' then search table D only.
Which method is better. Is breaking up into multile tables desirable at all ?
Pls let em know about this issue on MySQL.
Thanx in advance
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
