Fork me on GitHub
Get XOOPS XOOPSXOOPS FAQFAQ ForumsForums NewsNews ThemesThemes ModulesModules
News World of XOOPS Developers Hacks Modules Themes YAXS Archive Submit News

Search

Learn XOOPS Core

Donat-O-Meter

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

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 Blocks Bootstrap Captcha cell cent chronolabs CHUNG Clicks content CĂN demo docek download Dresses evden eve facebook Fat floor Food for free Gateway Google Guide herre Honeypot HP Human HỘ IP iPhone jQuery Language 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 Smoking Solution Spam Studio tag tags tdmcreate template The Theme themes web weight Wishcraft xoops Xortify

New Users

Registering user

# 137718

xxoopss

Welcome to XOOPS!

Archives

News Archives

DB Optimization Competition with Prizes

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