RE: [PHP] PHP/MySQL Performance

I've had upto 3,000,000 records on a table with a weaker machine than that... (At the time i think it was a P 500 / 128mb / 9GB SCSI) > -----Original Message----- > From: Michael Kimsal [mailto:michael@tapinternet.com] > Sent: Tuesday, October 31, 2000 10:29 PM > To: David Snowden > Cc: php-general@lists.php.net > Subject: Re: [PHP] PHP/MySQL Performance > > > Yes. > > Not sure what more you need to know. I'm running PHP/Mysql > on a p300 with 128 megs and a 6 gig IDE drive. > > 150,000 records, doing a LIKE '%stuff%' search through a BLOB > and the system still responds in <1 sec. > > David Snowden wrote: > > > I have been working with PHP & MySQL for awhile now but > never on a large > > scale site. > > > > I have a client who wants a database built for a record > store that will have > > over 100,000 items. > > > > Can MySQL handle this? > > Also, can anyone suggest a good place to start for building > high end PHP > > e-commerce sites in terms of security and performance, as > well as backing up > > data... > > > > I am also going to recommend that they get a dedicated > server with the > > following: > > PIII 800 > > 512MB RAM > > 18 Gig SCSI Drive > > > > Is this sufficient? > > > > I know this is kind of a weird email, but the only things > ive really done > > with PHP & MySQL is the kind of stuff you learn in Sam's 24 > Hour book and > > Juli Meloni's Essentials. > > > > Thanks!!! > > -- > ========================== > Michael Kimsal > http://www.tapinternet.com > 734-480-9961 > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >