Resend my activation email : Register : Log in 
BCF: Bike Chat Forums


An Idea! for Korn to speed up BCF

Reply to topic
Bike Chat Forums Index -> Forum Feedback & Help
View previous topic : View next topic  
Author Message

Itchy
Super Spammer



Joined: 07 Apr 2005
Karma :

PostPosted: 09:16 - 27 Apr 2010    Post subject: An Idea! for Korn to speed up BCF Reply with quote

How about the screen whereby it tells you that your post has been sucessfully added is removed completely saving an entire page having to be generated and an extra process on the server?

I mean I always click past it anyway and I doubt many people linger and watch it.
____________________
Spain 2008France 2007Big one 2009 We all die. The goal isn't to live forever, the goal is to create something that will. In the end, your life will flash before your eyes. Make sure it is worth watching.
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Clanger
Stirrer



Joined: 27 May 2004
Karma :

PostPosted: 09:46 - 27 Apr 2010    Post subject: Reply with quote

Maybe he'll read this today...like now...whilst he's logged on!!!

Actually, Itchy...that page rarely works for me anyway, that's when I get either a critical error and booted out, or I get a double post message.

I also don't see, when I return to the main forum that, my post has catapulted said thread to the top...it will sit showing the previous poster in the same position...until I click away and then come back!!!
____________________
Be who you are and say what you feel, because those who mind don't matter, and those who matter won't mind - Dr. Seuss
 Back to top
View user's profile Send private message You must be logged in to rate posts

Kickstart
The Oracle



Joined: 04 Feb 2002
Karma :

PostPosted: 10:57 - 27 Apr 2010    Post subject: Reply with quote

Hi

I suspect that page is an attempt to prevent double posts. Goes there then redirects to the thread page so that if someone reloads the page of the thread it doesn't resubmit the form for their post.

Korn added some caching to the index pages so they didn't need to be regenerated all the time. Suspect that is why the index doesn't always change immediately when you submit a post.

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

G
The Voice of Reason



Joined: 02 Feb 2002
Karma :

PostPosted: 21:05 - 01 May 2010    Post subject: Re: An Idea! for Korn to speed up BCF Reply with quote

It's not really adding much complexity - apart from the basic base html, you're not really going to save any database stuff. As mentioned, pretty sure it's also there to help prevent double posts.
 Back to top
View user's profile Send private message You must be logged in to rate posts

Alexio
World Chat Champion



Joined: 27 Aug 2009
Karma :

PostPosted: 22:40 - 01 May 2010    Post subject: Reply with quote

Also, that's just the way phpbb works Laughing
____________________
will never give up his CG. I look at my fuel gauge more as a progress bar than a fuel gauge.
G: With my GSXR I do often effectively use it as a scooter with a clutch in town.
ms51ves3: why does it need 500 miles? Are you teaching it how to be a piston?
 Back to top
View user's profile Send private message You must be logged in to rate posts

Kickstart
The Oracle



Joined: 04 Feb 2002
Karma :

PostPosted: 22:46 - 01 May 2010    Post subject: Re: An Idea! for Korn to speed up BCF Reply with quote

G wrote:
It's not really adding much complexity - apart from the basic base html, you're not really going to save any database stuff.


With the way phpBB works it does actually load data from databases. Every page in phpBB loads up the config table into an array, along with a load of other stuff from files such as the local language text for various things.

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

G
The Voice of Reason



Joined: 02 Feb 2002
Karma :

PostPosted: 23:01 - 01 May 2010    Post subject: Re: An Idea! for Korn to speed up BCF Reply with quote

I don't know how it works, but I'd have thought that stuff would be a lot more efficient than getting posts and other user data back.
 Back to top
View user's profile Send private message You must be logged in to rate posts

Alexio
World Chat Champion



Joined: 27 Aug 2009
Karma :

PostPosted: 23:19 - 01 May 2010    Post subject: Re: An Idea! for Korn to speed up BCF Reply with quote

G wrote:
I don't know how it works, but I'd have thought that stuff would be a lot more efficient than getting posts and other user data back.


Well next time you post have a look at how many queries it takes. Tell ya what, I'll post this post and then edit it to let you know how many queries happen in that short success page.

Edit:

Apparently 25 queries to show a success screen, 18 to show a thread, 14 to post a new post and 10 to edit this post. Madness I tell you! Although some queries are more database intensive than others obviously.
____________________
will never give up his CG. I look at my fuel gauge more as a progress bar than a fuel gauge.
G: With my GSXR I do often effectively use it as a scooter with a clutch in town.
ms51ves3: why does it need 500 miles? Are you teaching it how to be a piston?
 Back to top
View user's profile Send private message You must be logged in to rate posts

Kickstart
The Oracle



Joined: 04 Feb 2002
Karma :

PostPosted: 23:27 - 01 May 2010    Post subject: Reply with quote

Hi

Not sure if Korn has changed it, but a normal phpbb install goes to a fair amount of effort to use generic sql passed to a routine to access the database. The need to keep things generic will stop the use of any clever sql.

While it might take 25 queries to show the success screen, that will include all the queries used in saving the post.

Edit - to frighten yourself have a look at your profile (ie, the one get by clicking your name, not the link at the top of the page). Quick glance and that took 418 queries Shocked

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Itchy
Super Spammer



Joined: 07 Apr 2005
Karma :

PostPosted: 00:17 - 02 May 2010    Post subject: Reply with quote

Kickstart wrote:
Hi

Not sure if Korn has changed it, but a normal phpbb install goes to a fair amount of effort to use generic sql passed to a routine to access the database. The need to keep things generic will stop the use of any clever sql.

While it might take 25 queries to show the success screen, that will include all the queries used in saving the post.

Edit - to frighten yourself have a look at your profile (ie, the one get by clicking your name, not the link at the top of the page). Quick glance and that took 418 queries Shocked

All the best

Keith


No wonder looking at your profile always takes ages...
____________________
Spain 2008France 2007Big one 2009 We all die. The goal isn't to live forever, the goal is to create something that will. In the end, your life will flash before your eyes. Make sure it is worth watching.
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Korn
Admin



Joined: 01 Feb 2002
Karma :

PostPosted: 14:25 - 04 May 2010    Post subject: Reply with quote

Like Keith's already said those intermediate pages don't generate much in the way of load... most of the basic common queries (loading the config data out of the DB, etc) are mostly served from memcached these days, instead of actually hitting the MySQL DB.

One side-effect of the server move in Feb is that BCF is growing again, up by some 25% in terms of page views since the start of the year... which is cool, but is ultimately going to lead to even more kit being needed soon.
____________________
3516 Miles, 11 Countries
 Back to top
View user's profile Send private message Send e-mail Visit poster's website You must be logged in to rate posts

Alexio
World Chat Champion



Joined: 27 Aug 2009
Karma :

PostPosted: 14:42 - 04 May 2010    Post subject: Reply with quote

Korn wrote:
Like Keith's already said those intermediate pages don't generate much in the way of load... most of the basic common queries (loading the config data out of the DB, etc) are mostly served from memcached these days, instead of actually hitting the MySQL DB.

One side-effect of the server move in Feb is that BCF is growing again, up by some 25% in terms of page views since the start of the year... which is cool, but is ultimately going to lead to even more kit being needed soon.


I would theorise that the increase in "growth" could be partly due to the increased usability that has come from having a faster server for the existing users. I know that for me personally I can trawl through these forums much faster than I used to be able to and then do it again a lot sooner. It means no more giving up on BCF as it throws a fit again and waiting an hour because it's most likely not to have sped up before then.

It could just be the time of year too with the sun coming out and people remembering they have a bike again, although maybe the numbers of unique visitors really have increased.
____________________
will never give up his CG. I look at my fuel gauge more as a progress bar than a fuel gauge.
G: With my GSXR I do often effectively use it as a scooter with a clutch in town.
ms51ves3: why does it need 500 miles? Are you teaching it how to be a piston?
 Back to top
View user's profile Send private message You must be logged in to rate posts

The Shaggy D.A.
Super Spammer



Joined: 12 Sep 2008
Karma :

PostPosted: 14:48 - 04 May 2010    Post subject: Reply with quote

I still say ban traffic from India and Pakistan.

https://www.alexa.com/siteinfo/bikechatforums.com#
____________________
Chances are quite high you are not in my Monkeysphere, and I don't care about you. Don't take it personally.
Currently : Royal Enfield 350 Meteor
Previously : CB100N > CB250RS > XJ900F > GT550 > GPZ750R/1000RX > AJS M16 > R100RT > Bullet 500 > CB500 > LS650P > Bullet Electra X & YBR125 > Bullet 350 "Superstar" & YBR125 Custom > Royal Enfield Classic 500 Despatch Limited Edition (28 of 200) & CB Two-Fifty Nighthawk > ER5
 Back to top
View user's profile Send private message You must be logged in to rate posts

Korn
Admin



Joined: 01 Feb 2002
Karma :

PostPosted: 15:03 - 04 May 2010    Post subject: Reply with quote

The Shaggy D.A. wrote:
https://www.alexa.com/siteinfo/bikechatforums.com

The data Alexa bases that chart on is about as accurate as somebody with parkinson's trying to piss into a coke can from 10 feet away...

In reality most people are from where you'd expect:

https://www.bikechatforums.com/files/image3.gif
____________________
3516 Miles, 11 Countries
 Back to top
View user's profile Send private message Send e-mail Visit poster's website You must be logged in to rate posts

Clanger
Stirrer



Joined: 27 May 2004
Karma :

PostPosted: 16:06 - 04 May 2010    Post subject: Reply with quote

I honestly don't know why I re-visit these forum feedback posts after I've written something...I don't understand a thing you lot are saying...you may as well be talking gobbledegook. I wonder if this is what dyslexic people feel like when looking at plain old English text. Thinking
____________________
Be who you are and say what you feel, because those who mind don't matter, and those who matter won't mind - Dr. Seuss
 Back to top
View user's profile Send private message You must be logged in to rate posts
Old Thread Alert!

The last post was made 15 years, 271 days ago. Instead of replying here, would creating a new thread be more useful?
  Display posts from previous:   
This page may contain affiliate links, which means we may earn a small commission if a visitor clicks through and makes a purchase. By clicking on an affiliate link, you accept that third-party cookies will be set.

Post new topic   Reply to topic    Bike Chat Forums Index -> Forum Feedback & Help All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Read the Terms of Use! - Powered by phpBB © phpBB Group
 

Debug Mode: ON - Server: birks (www) - Page Generation Time: 0.08 Sec - Server Load: 0.33 - MySQL Queries: 14 - Page Size: 92.62 Kb