Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Speeding up MySQL Queries for faster performance using MySQL Cache
02-24-2012, 11:56 AM
Post: #1
Speeding up MySQL Queries for faster performance using MySQL Cache
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.
Find all posts by this user
Quote this message in a reply
03-02-2012, 02:33 AM
Post: #2
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
Isn't MySQLi much easier to use than this?
Find all posts by this user
Quote this message in a reply
03-04-2012, 02:52 PM
Post: #3
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
i will use it thank's
Find all posts by this user
Quote this message in a reply
03-20-2012, 06:34 PM
Post: #4
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
Ididnt know this thanks Big Grin
Find all posts by this user
Quote this message in a reply
04-22-2012, 04:22 PM
Post: #5
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
Thanks.
Find all posts by this user
Quote this message in a reply
04-23-2012, 03:25 AM
Post: #6
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
I also thought MySQLi is for this too.

What's the difference?
Find all posts by this user
Quote this message in a reply
05-03-2012, 02:32 PM
Post: #7
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
Thanks a lot.
Find all posts by this user
Quote this message in a reply
10-08-2012, 08:05 AM
Post: #8
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
Thank you for sharing this with us it seems very useful .. I'll be back with the results of testing.
Find all posts by this user
Quote this message in a reply
10-29-2012, 08:03 AM
Post: #9
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
hey thats a really nice trick, also you can increase mysql cache size for furthur increase in performance.
Find all posts by this user
Quote this message in a reply
11-02-2012, 03:34 PM
Post: #10
RE: Speeding up MySQL Queries for faster performance using MySQL Cache
Wow, nice trick.. I actually avoided this topic because I thought I'd need some library, or something.. Cool, thanks Wink
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | Homepage | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication