') ') Fork me on GitHub

Search

Donat-O-Meter

Make donations with PayPal!
Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $10.00
Net Balance: $9.41
Left to go: $90.59

Donations
Dante7237  ($10)Dec-3

Learn XOOPS Core

Local Support

Advertisement

XOOPS Code hosted on SourceForge

Cumulus Tag Cloud

- 2 2.5 2.6 3.0 4 6 2013 Abuse Android AntiHarvesting AntiMalUser AntiSpam API Apple Battlefield Blocks Bootstrap By Captcha cell chronolabs Clicks content CĂN demo docek download Dresses evden eve facebook Fat Food for free Gateway giải Google Guide herre Home Honeypot Human HỘ IP iPhone jQuery Law Legal List Loss mobile module modules Monster new newbb news nhiệt NHÀ online PARK Payment phone PHP Prevention profile project Protector publisher Rapid release RESIDENCE responsive review Rights rmcommon security Sentry Signed site Smartphone Smoking Solution Spam Studio tags tdmcreate The Theme themes web weight Wishcraft xoops Xortify XPayment

New Users

Registering user

# 137911

mydarkglobe

Welcome to XOOPS!

Archives

News Archives

DB Optimization Competition with Prizes

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

http://webyog.com/en/sqlyog_feature_matrix.php

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:

http://www.percona.com/files/presenta ... ql-query-optimization.pdf

http://www.slideshare.net/guest9912e5 ... l-application-performance

http://www.slideshare.net/posullivan/ ... 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 10:23 • Updated: 2012/6/13 10:23
BTW, to qualify for contest one should tweet why they like SQLyog.
Or use simply this - http://bitly.com/M5TNtV
Published: 2012/6/19 16:08 • Updated: 2012/6/19 16:08
Two more weeks left!

Is anybody working on anything?
Published: 2012/7/1 22:55 • Updated: 2012/7/1 22: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/1 23:06 • Updated: 2012/7/1 23:06