AntiWPA Forum

MySQL Queries Can Really Kill Your Web Server. Yes its true that writing buggy SQL queries can result in a lot of server cpu usage. Many webmasters face this problem and they think that their service provider is not good and blah blah.

Best Example is of wapsites using sea 8.1 Script.

if you are in one of them or your server is getting overloaded because of MySQL then i will suggest you to look at below method of caching can help in reducing the cpu usage of a script.

ok so below is the way on how to use SQL cache.

Suppose your have a query
SELECT name from users where name='xtra';

so query with cache will be like this:
SELECT SQL_CACHE name from users where name='xtra';


This Will stores the result in cache.
Using This Can reduce Your Memory Requirement and load Your Site Faster


Similarly there are a lot of ways to improve and reduce the server load by optimizing the SQL queries.

Isn't MySQLi much easier to use than this?

i will use it thank's

Ididnt know this thanks

Thanks.

I also thought MySQLi is for this too.

What's the difference?

Thanks a lot.

Thank you for sharing this with us it seems very useful .. I'll be back with the results of testing.

hey thats a really nice trick, also you can increase mysql cache size for furthur increase in performance.

Wow, nice trick.. I actually avoided this topic because I thought I'd need some library, or something.. Cool, thanks