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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
