Fork me on GitHub



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

Learn XOOPS Core

Local Support


XOOPS Code hosted on SourceForge

Cumulus Tag Cloud

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

New Users

Registering user

# 138593


Welcome to XOOPS!


News archives

DB Optimization Competition with Prizes

Posted by Mamba on 2012/6/15 4:10:00 (4303 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