Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2010-08-15 15:44:29

milki
New Member
From: .eu
Registered: 2010-08-15
Posts: 1

Parameterized SQL, and less queries

New to Textpattern.
But there’s one thing I’d like to see in future versions. I assume TP developers are careful in making sure every database call is properly escaped. But personally I believe it’s more professional to use parameterized SQL instead of carefulness.
Not to be a complainer, and I realize this is a bigger undertaking, so I’d also offer my help in transitioning some code off old-style SQL string concatenation.

Also, my vanilla TP setup already does 27 database queries per page, which seems a whole lot. Obviously configurability comes at a price, but I hope there are some optimizations in store there too.

G!

Offline

#2 2010-08-15 17:36:01

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: Parameterized SQL, and less queries

Submit patches, but keep in mind that they shouldn’t break compatibility with existing plugins.

Offline

#3 2010-08-16 06:37:14

wet
Developer Emeritus
From: Schoerfling, Austria
Registered: 2005-06-06
Posts: 3,330
Website Mastodon

Re: Parameterized SQL, and less queries

milki wrote:

Also, my vanilla TP setup already does 27 database queries per page, which seems a whole lot.

By what metric did you judge?

Offline

Board footer

Powered by FluxBB