Free Republic
Browse · Search
News/Activism
Topics · Post Article

Skip to comments.

Suggestions to possibly make your FR pages load faster [thread II]
Prior thread ^

Posted on 10/31/2012 6:35:41 PM PDT by Jim Robinson

click here to read article


Navigation: use the links below to view more comments.
first 1-2021-4041-6061-8081-97 next last

1 posted on 10/31/2012 6:35:41 PM PDT by Jim Robinson
[ Post Reply | Private Reply | View Replies]

To: Jim Robinson
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?

2 posted on 10/31/2012 6:40:44 PM PDT by Carry_Okie (Islam offers us choices: convert or kill, submit or die.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson

Thanks for all you do!


3 posted on 10/31/2012 6:43:14 PM PDT by rdl6989 (January 20, 2013 The end of an error.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson

Thanks Jim


4 posted on 10/31/2012 6:45:50 PM PDT by blueyon (The U. S. Constitution - read it and weep)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson

Can you make all that the default on election day?


5 posted on 10/31/2012 6:48:06 PM PDT by GeronL (http://asspos.blogspot.com)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson

Mine loads just fine—couldn’t be faster.

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


6 posted on 10/31/2012 6:48:24 PM PDT by basil (Second Amendment Sisters.org)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson

             

7 posted on 10/31/2012 6:49:33 PM PDT by tomkat ( let's HANG traitors again, shall we ?!)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson

             

8 posted on 10/31/2012 6:50:27 PM PDT by tomkat (thinks HANGING traitors is still a good idea)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson

BTTT!


9 posted on 10/31/2012 6:50:51 PM PDT by The Mayor ("If you can't make them see the light, let them feel the heat" — Ronald Reagan)
[ Post Reply | Private Reply | To 1 | View Replies]


grrrrrrr
10 posted on 10/31/2012 6:51:16 PM PDT by tomkat (thinks HANGING traitors is still a good idea)
[ Post Reply | Private Reply | To 8 | View Replies]

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

Now what?

11 posted on 10/31/2012 6:52:48 PM PDT by E. Pluribus Unum (Government is the religion of the psychopath.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: basil

Mine’s a Mac too, but I had trouble. Did what Jim recommended above and my load time is now 90% faster.


12 posted on 10/31/2012 6:54:48 PM PDT by freeagle
[ Post Reply | Private Reply | To 6 | View Replies]

To: E. Pluribus Unum

To reset your preferences next week after Obama is evicted and the tea party tsunami sweeps the socialists out of office from sea to shining sea, click on “Account” at the top of any of the main index pages and then “Manage Blocks” to configure your sidebars and “My Preferences” to reset your number of threads and replies per thread preferences.

http://www.freerepublic.com/focus/my/


13 posted on 10/31/2012 7:07:23 PM PDT by Jim Robinson (Resistance to tyrants is obedience to God!!)
[ Post Reply | Private Reply | To 11 | View Replies]

To: Jim Robinson

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.


14 posted on 10/31/2012 7:12:09 PM PDT by HannibalHamlinJr
[ Post Reply | Private Reply | To 1 | View Replies]

To: basil

Pages seem to load faster with Safari — but it’s still unbearably slow.


15 posted on 10/31/2012 7:20:26 PM PDT by smokingfrog ( sleep with one eye open (<o> ---)
[ Post Reply | Private Reply | To 6 | View Replies]

To: Jim Robinson

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.


16 posted on 10/31/2012 7:24:54 PM PDT by Brown Deer (Pray for 0bama. Psalm 109:8)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Jim Robinson
Do not disable "tools" or you will no longer have a "configure sidebar" link, and you will not be able to undo what you did.

I managed to open a cached version of the configuration page with Firefox's "undo close tab" and fixed it.

17 posted on 10/31/2012 7:25:37 PM PDT by E. Pluribus Unum (Government is the religion of the psychopath.)
[ Post Reply | Private Reply | To 13 | View Replies]

To: smokingfrog

I’m also using Safari—and mine is loading lickety split. Don’t know what the difference could be....


18 posted on 10/31/2012 7:32:53 PM PDT by basil (Second Amendment Sisters.org)
[ Post Reply | Private Reply | To 15 | View Replies]

To: 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.”””””

because it’s jim’s way or the highway.....no ideas from outside are allowed lest you be belittled and put down for offering legitimate suggestions.....

full disclosure....i am a past $1.00 a day donor.....


19 posted on 10/31/2012 7:33:42 PM PDT by is_is (VP Dad of Sgt. G - My Hero - "Sleep Well America......Your Marines have your Back")
[ Post Reply | Private Reply | To 2 | View Replies]

To: HannibalHamlinJr

Yup. And we’ve concluded the same. It’s back to the drawing board design wise to grow to the next level. Thank you very much!!


20 posted on 10/31/2012 7:35:58 PM PDT by Jim Robinson (Resistance to tyrants is obedience to God!!)
[ Post Reply | Private Reply | To 14 | View Replies]


Navigation: use the links below to view more comments.
first 1-2021-4041-6061-8081-97 next last

Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.

Free Republic
Browse · Search
News/Activism
Topics · Post Article

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson