Fork me on GitHub



Make donations with PayPal!
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00

GitHub Twitter

Learn XOOPS Core

Local Support


XOOPS Code hosted on SourceForge

Cumulus Tag Cloud

- 2 2.5 2.6 4 6 admin adslight Android AntiHarvesting AntiSpam API Apple Battlefield billige Blocks Bootstrap Captcha cell cent chronolabs Clicks Cloud content CĂN demo download Dresses facebook Fat floor Gateway giải Google Guide herre Home Honeypot html5 Human HỘ IP iPhone jQuery Language Law Legal List log Loss module modules Monster new newbb news nhiệt NHÀ online PARK Payment phone PHP Plugin Prevention profile project Protector publisher RESIDENCE responsive review Rights Room security Sentry Signed site Smartphone Smarty Smoking Solution Spam stem Studio support tag tdmcreate The Theme themes User userlog weight xoops Xortify XPayment ZendFramework

New Users

Registering user

# 139414


Welcome to XOOPS!


News archives

DB Optimization Competition with Prizes

Posted by Mamba on 2012/6/15 4:10:00 (4553 reads) | Posted on XOOPS
Calling all MySQL experts out there!

Recently we had some reports about Core and some modules generating too many queries, as reported by Tatane and Yasir

We would like to announce a competition for best/most MySQL database optimizations in XOOPS. This can happen in following areas:

a) existing Core queries
b) existing popular modules
c) new module with the best optimized way to access and manage MySQL database, incl. a tutorial on how it was done

Please submit your entries by July 15

This competition is sponsored by Webyog, which offers SQLyog, one of the best MySQL tools on the market. See the features here:

They offered to give us up to 5 copies of the Ultimate version (worth $179 each) to winners of a competition among XOOPS developers. Of course, it will depend on the number and quality of the entries, if we will use all five copies.

There are many very good tutorials and presentations about optimizing MySQL, but we're sure, you all know those tricks: ... ql-query-optimization.pdf ... l-application-performance ... g-and-optimizing-your-sql

Let's see how could we use them to improve our Core and our Modules.

You can post solutions in this thread on Forums.

Printer friendly page Send this story to a friend Create a PDF from the article
Bookmark Me
Bookmark to Google Plus
The comments are owned by the author. We aren't responsible for their content.

Great! Xoops really need this, mostly in core :)
Published: 2012/6/13 11:23 • Updated: 2012/6/13 11:23
BTW, to qualify for contest one should tweet why they like SQLyog.
Or use simply this -
Published: 2012/6/19 17:08 • Updated: 2012/6/19 17:08
Two more weeks left!

Is anybody working on anything?
Published: 2012/7/1 23:55 • Updated: 2012/7/1 23:55
Well Michael, we talked about my work on PDO and MySQLi ports...

Hope to have those done this week if I can get time to work on them.

Certainly before the deadline is due.

(Procedural MySQLi is done short of the Transactions and Prepared Statements, PDO is about 80% done for MySQL.. I just need to debug it and add error logging support as well as Transactions and Prepared statements. Will also attempt an OOP version of the MySQLi as well since it should work similar to the PDO script.)

These in themselves won't do much until they get utilized by modules and such and make use of the prepared statements and transactions but it is certainly a move in the right direction.
Published: 2012/7/2 0:06 • Updated: 2012/7/2 0:06