20+ queries when posting

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
User avatar
chAos
Registered User
Posts: 259
Joined: Wed Jan 16, 2002 7:05 am

20+ queries when posting

Post by chAos »

Will the amount of queries when making a post (the confirmation page right after you hit submit) be reduced?

20+ is a fair amount.
Darkshines
Registered User
Posts: 40
Joined: Thu Jan 24, 2002 7:14 pm
Location: Leyland, Lancashire

Re: 20+ queries when posting

Post by Darkshines »

I think maybe it depends on how long your post is. Something to do with the search indexes, maybe.
Then again...
User avatar
psoTFX
Registered User
Posts: 1984
Joined: Tue Jul 03, 2001 8:50 pm
Contact:

Re: 20+ queries when posting

Post by psoTFX »

sigh, queries are not the be all and end all of everything chAos ;) Take a look @ the code and see what it does for yourself ... if there is scope to reduce the query count we'll do so.
Last edited by psoTFX on Sat Apr 26, 2003 11:56 am, edited 1 time in total.
User avatar
SHS`
Registered User
Posts: 1628
Joined: Wed Jul 04, 2001 9:13 am
Location: The Boonies, Hong Kong
Contact:

Re: 20+ queries when posting

Post by SHS` »

Indeed, as Paul says, it not just query count, since a large number of very quick queries can be faster overall than a few very complex ones. It's all about balance.

However, I did a little benchmark using the "10 Commandments of phpBB", which contains lots of nested BBCode posting it to a 2.0.4 and 2.1 CVS, with mostly implimented text parser.

2.0.4 managed to process the post between 1.70 to 2.10 seconds.

2.1 CVS managed this in a scant 0.50 to 0.60 seconds, even though the query count is "comparable".
Jonathan “SHS`” Stanley • 史德信
phpBB™ 3.1.x, Bug/Security trackers
phpBB™ Bertie Bear 3.0 — prosilver Edition!Asking Questions The Smart Way
Darkshines
Registered User
Posts: 40
Joined: Thu Jan 24, 2002 7:14 pm
Location: Leyland, Lancashire

Re: 20+ queries when posting

Post by Darkshines »

Don't forget, the number of files you load makes a difference as well as the queries ;)

Although we are on the subject of queries not necessarily being important well... hm, never mind then :P
Then again...
soxie
Registered User
Posts: 160
Joined: Thu Mar 13, 2003 1:08 am
Location: Boston, MA
Contact:

Re: 20+ queries when posting

Post by soxie »

SHS` wrote:2.0.4 managed to process the post between 1.70 to 2.10 seconds.

2.1 CVS managed this in a scant 0.50 to 0.60 seconds ...
Woo.. that's awesome and amazing. :)
brian.
http://itsbrian.blogspot.com/" target="_blank
User avatar
espenhh
Registered User
Posts: 189
Joined: Sun Mar 17, 2002 8:27 pm
Location: Norway ;)
Contact:

Re: 20+ queries when posting

Post by espenhh »

Realy great!!!!!!! :D

Look forward to the release!!!
Espen

(Huge thanks to the phpBB-developers!!!)

Need Norwegian support????
Image
User avatar
chAos
Registered User
Posts: 259
Joined: Wed Jan 16, 2002 7:05 am

Re: 20+ queries when posting

Post by chAos »

hmm.... i will go and have a look at the code after this, but i was just wondering cause generally speaking, smaller numbers can be better than bigger numbers. ;)

Thanks.
User avatar
psoTFX
Registered User
Posts: 1984
Joined: Tue Jul 03, 2001 8:50 pm
Contact:

Re: 20+ queries when posting

Post by psoTFX »

That's not necessarily true for SQL ;)
Draegonis
Registered User
Posts: 368
Joined: Thu Apr 24, 2003 11:35 am

Re: 20+ queries when posting

Post by Draegonis »

Syntax highlighting is really really nice, but is there any chance of getting the font size a little larger? It's pretty hard to read, and that's *with* my glasses on. :P
Post Reply