Just a thought - but do your web pages actually display all 150K records at once? YOu may want to change how your page requests and do limits, and just do grabs at 100 at a time, or so. UNless of course you are processing all 150K in one big calculation of some sort - but then, I wouldnt do that webbased
On Fri, 14 May 2004 06:52 , rmck <[EMAIL PROTECTED]> sent: >Is there a good tutorial on installing Mysql on one machine and having Apache on >another? > >I'm thinking on the server with Apache I guess you would just compile Apache with >the mysql/php and in your php scripts just point to the hostname of the mysql server? Making sure you can talk to port 3306. > >Has anyone seen performance issues with large databases and the results going over >tcp, instead of the local installs which i use sockets? > >Some of my query results return 150,000 records. > >Im just running out of ram on the machine with both Apache/mysql and I cant upgrade >to anymore memory for my dell server, at 4gb ram. > >rob > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > ------------------------------------------- Chris McKeever If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com http://www.prupref.com Prudential Preferred Properties Chicago and Illinois NorthShore Real Estate Experts ---- Prudential Preferred Properties www.prupref.com Success Driven By Results Results Driven By Commitment Commitment Driven By Integrity We Are Prudential Preferred Properties -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]