Re: Is MySQL enough for a huge amount of data?

mysql is better for quick and light....less overhead than postgress, less functionality too. overall, if you sit and tune it, you can get postgress to run better, but who has the time. "Andy" <news.letters@gmx.de> wrote in message news:20011214122826.47843.qmail@pb1.pair.com... > Hi there, > > I am wondering if I could have MySQL as a DB for an Application which needs > to have access a table of 1 Mio entries. > And how long would it take to get an entry out of it. Asuming it contains > only a name field and an id. > e.g. > > select name > from cities > where provincial id = 2 > > If it works, how could I optimize the table? > > Thanx for you help guys > > Cheers Andy > >