Fork me on GitHub

Search

Donat-O-Meter

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

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 adslight Android AntiHarvesting AntiMalUser AntiSpam API Apple Battlefield billige Bootstrap Captcha cell chronolabs CHUNG content CĂN demo docek download Dresses evden eve facebook Fat floor Food for free Gateway Google Guide herre Home Honeypot HP Human HỘ IP iPhone jQuery Language Law Legal List log Loss mobile module modules Monster new newbb news NHÀ online PARK phone PHP Prevention profile project Protector publisher Rapid RESIDENCE responsive review Rights rmcommon security Sentry site Smartphone Solution Spam Studio tags tdmcreate template The Theme themes User userlog web weight Wishcraft xoops Xortify

New Users

Registering user

# 137849

hometheater

Welcome to XOOPS!

Archives

News Archives

DB Optimization Competition with Prizes

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