ID #1103

SQLyog seems to be very fast compared to other MySQL Tools. Why?


Yes, SQLyog will completely "thrash" most other client software when it comes to raw speed. There are a handful of reasons:



Most client software uses wrapper classes (.NET wrapper or DELPHI wrapper) to access MySQL. This adds a significant overhead. SQLyog, on the other hand is written in C/C++ and low-level Win32 APIs.

SQLyog uses MySQL C API to communicate with MySQL. MySQL C API is by far the fastest interface to MySQL.



SQLyog is written exclusively for MySQL so we have made a lot of optimizations specific for MySQL. Other front-ends that connect to multiple database systems most often try to share a lot of code across various editions of the product. Hence, they are not fully optimized for MySQL.


Tags: -

Related entries:

You can comment this FAQ