MySQL Hacks and Tricks to Make Phorum Fast

Brian Moon (dealnews.com)

4:25pm Wednesday, 04/16/2008

Performance Tuning and Benchmarks, PHP and MySQL
Location: Ballroom A

Phorum is the message board software used by MySQL. One reason they chose Phorum was because of its speed. We have to use some tricks and fancy SQL to make this happen. Things we will talk about in this session include:

Using temporary tables for good uses.
Why PHP and MySQL can be a bad mix with large data sets.
What mysqlnd will bring to the table with the future of PHP and MYSQL.
How Phorum uses full text indexing and some fancy SQL to make our search engine fast.
Forcing MySQL to use indexes to ensure proper query performance.

People planning to attend this session also want to see:

Brian Moon

dealnews.com

Brian Moon has been working with the LAMP platform since before it was called LAMP. He is the Senior Web Engineer for dealnews.com. He has made a few small contributions to the PHP project and been a casual participant in discussions on the PHP internals list. He is the founder and lead developer of the Phorum project, the first PHP/MySQL message board ever created.

Web site

Schedule views

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com.

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for more information on trade opportunities with O'Reilly conferences, or contact mediapartners@oreilly.com.

Press and Media

For media-related inquiries, contact confpr@oreilly.com.

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.