Did you go look at: www.mysql.com?? Russ
On Fri, 14 Dec 2001 13:27:03 +0100 Andy <[EMAIL PROTECTED]> wrote: > 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] > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------# -- 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]
