Computing.Net > Forums > Database > Php mysql

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Php mysql

Reply to Message Icon

Name: yagu
Date: February 18, 2009 at 02:56:02 Pacific
OS: Windows XP
Subcategory: MS SQL Server
Comment:

suppose in my site i'm getting 1 million query in a second and database is mysql so it may cause a problem to hang up the server ... how i avoid this thing



Sponsored Link
Ads by Google

Response Number 1
Name: David Perry
Date: June 5, 2009 at 12:28:55 Pacific
Reply:

1M/second is quite a high number. You may be able to reduce some of the db load by normalizing the data as well as copying frequent data to temp tables. Avoid joins if you have the opportunity.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Php mysql

PHP / MySQL Retrieve one record www.computing.net/answers/dbase/php-mysql-retrieve-one-record/255.html

MySQL: Storage Engine/Field Type www.computing.net/answers/dbase/mysql-storage-enginefield-type/268.html

PHP / MySQL Problem www.computing.net/answers/dbase/php-mysql-problem/274.html