[Carry_Okie]

How about setting up FR with levels of services corresponding to what people pay? Free riders would get the forum and a limited self-search, FR mail, etc, but no sidebars or bookmarks.

Thoughts?

[rdl6989]

Thanks for all you do!

[blueyon]

Thanks Jim

[GeronL]

Can you make all that the default on election day?

[basil]

Mine loads just fine—couldn’t be faster.

I’m on a Mac—if that could make a difference.

[tomkat]

             

[tomkat]

             

[The Mayor]

BTTT!

[E. Pluribus Unum]

I disabled some things, and now I no longer have a "Configure" link to undo it.

Now what?

[HannibalHamlinJr]

Thanks - I’ll reduce components.

Jim - this is database contention. Either the database is not a robust enough product, or it’s being bogged down by unnecessary or un-optimized queries and/or stored procedures. ( I posted something about this on the last thread but it timed out :-))

I’m assuming that over time, as features were added, they included an increasing number of queries per request. However, requests to reply and to actually post the reply are what take the longest.

While it’s true that at peak times all queries, including just viewing, get bogged down, at medium-peak, when ‘view’ requests do okay, web requests to reply to posts and then to commit posts are delayed, hang or time out.

Since FR only delivers text and doesn’t actually do the delivery of images or anything heavier, and since there is a discrepancy between ‘view’ requests and ‘insert edit’ requests, I don’t think it’s the web server or pipe-traffic issues.

The discrepancy can be explained by the database itself or communication with the database. Perhaps even a request to post a reply, not the post itself, requires an insert in the database in order to acquire an ID, and perhaps it re-queries to get that ID. otherwise it should behave as a ‘view’ page.

Can’t say - but I’m willing to bet it’s 80% database issues, and the rest is just a result of traffic backup caused by DB issues.

if the database is robust enough for the traffic but still failing, then it’s embedded SQL fired from web server scripts (or against stored procs) - either too many per request, or not optimized (either the sql itself or internally at the DB server.)

There need to be prepared, cached and optimized queries and views, fewer separate queries from page requests and probably an indexing strategy is interfering with inserts based on the discrepancy between read-only page load times and insert/update load times. Could also be a DB resource locking strategy problem explaining the increased time during edits/inserts.

I’m happy to donate time to help, but having dealt with all of this before, unless there are memory issues, which I doubt because the architecture isn’t that complex, diagnosing this shouldn’t be insurmountable.

Regardless - hope it gets worked out, it’s a great community and while I’m sure it won’t get worked out by election time (especially if it is in fact script and/or DB code - which I strongly suspect - rather than hardware or pipe replacement or increase) ... it’s not necessary for it to continue.

I’m not a monthly donor (yet)- kind of waiting for this to get identified. But I don’t think it’s a money issue to diagnose. Again - happy to donate help, and possibly I’m off since I can’t see the code itself - not trying to be presumptuous.

Best - and continued thanks for the site.

[Brown Deer]

not sure how this helps, since I get errors just going to the settings pages.

It took me about 20 tries just to post one small message the other night.

this seems to be the only site that I’ve been consistently having these problems (doesn’t seem to matter when), so it would seem to be either a configuration/database/programming problem.

[BerryDingle]

Thanks Jim!

[Albion Wilde]

ping to peak FR traffic guidelines

[Born to Conserve]

I’m not sure what level of programmer you have on staff, but I know that I was a super-genius programmer until I took a few grad school computer science courses, and became a mediocre programmer.

Just saying I hope your programmer has been initiated to the inner sanctum of programming, and has had a few courses in operating systems and concurrency.

Good luck next week.

[Jet Jaguar]

Thanks for the tips. Seems to work better here.

[GQuagmire]

bookmark

[Intolerant in NJ]

I disabled most of my sidebars as suggested - seems to have helped significantly.....

[X-spurt]

Thanks Jim for the info, reconfiged per suggestions and hope it helps. Figured you all were busy as a cat covering it up on a tin roof.

Election night is going to be crazy. Hope the Unable to Connect grey screen is rare.

[ConservativeStatement]

Thanks. The suggestions have been followed.

[gunsequalfreedom]

JimRob,
I’ve been on here since 2000 and love FR. I remember the days when people would forget to switch off the bold and every post after would be bold until one of us switched off.

You fixed that and you will get a handle on this one too.

Again, FR has been a wonderful website. Thanks! Big thanks!