[wp-hackers] Introduction & Question

[Angsuman Chakraborty]

A lot of WordPress coding decision are guided by backward compatibility as
it should be. So a decision to use stored procedures should be backed by:

1. Actual tests with prototype demonstrating performance benefits. I don't
think there would be significant benefits as there aren't many repetitive
queries.
Queries can be cached if you use object caching. Also the whole page is
cached if you use page caching plugin like wp-cache 2. Normally application
servers benefit from using stored procedures. WordPress serves requests
using PHP in a one-off fashion. Unless it is redesigned to take advantage of
persistence of data across requests, stored procedures isn't going to help
much.

2. Automatic Fallback to using plain SQL queries to support earlier MySQL
version

--Angsuman
-----Original Message-----
From: wp-hackers-bounces at lists.automattic.com
[mailto:wp-hackers-bounces at lists.automattic.com]On Behalf Of Chris
Poteet
Sent: Friday, January 19, 2007 8:41 AM
To: wp-hackers at lists.automattic.com
Subject: [wp-hackers] Introduction & Question
Importance: Low


All,

I'm new to the WP development team.  I have decided it's time that I give
back what has been given to me.  I look forward to making mistakes and being
laughed at (I'm sure) by the veterans.

Excuse this if it's already been asked, but is it a consideration to update
WP to use stored procedures that are now allowable in MySQL 5?
http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

Chris Poteet

_______________________________________________
wp-hackers mailing list
wp-hackers at lists.automattic.com
http://lists.automattic.com/mailman/listinfo/wp-hackers