One of most loved feature of SQLyog is the snappy and responsive user interface. Many of our users and customers prefer SQLyog over other tools because of this particular reason.
One reason for the zippy interface could be that SQLyog is entirely developed in C/C++, which tends to be faster than other languages when it comes to raw speed. I don’t want to start a flame war here, but our customers seem to like this fact. Using C/C++ allows us to use the native MySQL C client libraries that gives the best performance as compared to other ways of communicating with MySQL. Using C/C++ also ensures that there are no external dependencies on any bulky frameworks and the download file is relatively small.
Although using a language that complies directly to machine instructions helps a lot, but true speed comes from better algorithms. A similar analogy in the MySQL context would be that you might get some benefits from tuning your mysql.cnf/mysql.ini file, but real benefits come only when you find problematic queries in your application and rewrite them and/or create better indexes.
SQLyog uses a set of smart algorithms for its data synchronization tools. These algorithms ensure that we only transfer checksums using multiple threads and do full row transfer only when required. We have an old blog post with some benchmarking results here.
Although our data sync speeds are quite impressive, we were not happy with the results in certain scenarios. This led us to improve the data sync speeds even further with 8.1. We will publish some new benchmarking results soon in our blog.
With 8.1, we have been able to introduce massive speed improvements in the following areas:
- Data synchronization
- Auto complete
- Export as SQL (including Scheduled Backups), CSV and XML
Wait, we are not finished yet with the improvements in 8.1. This release introduces the following major features:
- Completely revamped Objects tab. The tab has been renamed to “Info”. The contents are now available in nicely formatted HTML in addition to the old text format
- Direct import of Access, Excel and CSV files. Now you don’t need to create ODBC DSN to import these file types. Just point to the files and SQLyog does the rest
Last but not the least, we continue to improve the usability with every release of SQLyog. With 8.1 we have made the following GUI changes:
- Added an option to ‘preview SQL’ in CREATE/ALTER TABLE
- Column width in all GRIDs (not only DATA and RESULT tabs) are now persistent
- New GUI for defining ENUM and SET columns in Create/Alter GUI
- Some reorganisations of menus, improved captions and explanations in dialogues and wizards etc
Needless to say, this release contains many bug fixes, UI improvements and minor features.
We are very excited about this release, and hope that you will like it. We would love to hear from you.
For the complete changelogs, please refer to the following posts:
- SQLyog 8.1 RC3 Release Notes
- SQLyog 8.1 RC2 Release Notes
- SQLyog 8.1 RC Release Notes
- SQLyog 8.1 beta1 Release Notes