Apolyton Archive  |  Preserved copy of the Apolyton Civilization Site and its forums as they stood in September 2005. Read-only; nothing here can be posted to or replied to.  |  Forum index |  About this archive |  The 1998–2001 UBB forums
Today on Apolyton WARDELL INTERVIEW PROMO A.C.S. HISTORY CHAPTER 4 GET CIV4 /w FREE PLUS! A.C.S. PHOTO GALLERY GET A.O.M. V1.1
Apolyton Civilization Forums
main| civ2| civ3| civ4| smac| ctp2| ron| moo3| galciv| galciv2| alt| about|
ApolytonPLUS | register | search | faq | new posts | pm (-/-) | upload | members
hall of fame new! | civgroups | civgroups news | interviews | the column | radio | chat | directory | news | store | PLUS
Apolyton Civilization Forums : Powered by vBulletin version 2.0.3 Apolyton Civilization Forums > Miscellaneous > Apolyton/Community > Loading User Profiles
Show a Printable Version | Email This Page to Someone! | Receive updates to this thread | Report this to Apolyton news!
20.Sep: FOURTH CHAPTER IN `HISTORY OF...` PUBLISHED
13.Sep: NEWS ON THE FLY
06.Sep: APOLYTON DONATES TO HURRICANE RELIEF
CivGroups
Apolytoners Hall of Fame (66): Not a Member - Join

bottom of page
   - CIVILIZATION 3 $9.99 - CIVILIZATION 2 from $6.95 - CIVILIZATION 2 from $4.25 - ALPHA CENTAURI + ALIEN CROSSFIRE (laptop collection) from $19.99 - ALPHA CENTAURI PC $9.99 -->
Author
Thread    < Last Thread     Next Thread > Post New Thread     Post A Reply
Trip is offline Trip
Firaxis Games
Hunt Valley
Apr 2002
time: 00:36
  Old Post 01-03-2005 08:18 Visit Trip's homepage!
Edit/Delete Message Reply w/Quote
#1 Report this post to a moderator
Loading User Profiles Increase Your PM Length

Why is it that trying to view a user's profile takes so much longer than anything else? Even editting didn't take so long back in the day when it was flowing like molassas...

vovan is offline vovan
Emperor

Oct 2001
time: 06:36
  Old Post 01-03-2005 09:19
Edit/Delete Message Reply w/Quote
#2 Report this post to a moderator
Avatar Enlargement: We've got the solution

I'd guess that may be because it has to pull data from several different tables. It needs to get the user info from the users' table, the latest post from the posts table, etc. Also, since the user profiles are not accessed very often (not by far, as compared to, say, posts), the actualy table is probably not so well optimized, indexed, and what not.

Just my guess.

Vovan

Shogun Gunner is offline Shogun Gunner

Emperor
Potomac Falls, Virginia
Oct 2000
time: 00:36
  Old Post 01-03-2005 10:33 Visit Shogun Gunner<br><a href=/members><img src=/forums/images/supporter-icon.gif border=0></a><BR>'s homepage!
Edit/Delete Message Reply w/Quote
#3 Report this post to a moderator
Support Apolyton, pre-order Civilization IV

I have noticed -- and I'm not sure if it's coincidence or real -- that more active users' profiles come up faster versus someone who hasn't posted in some time.

When I click my profile, it comes up pretty quickly. Clicking another active member, is not as fast, but can be reasonably fast enough...and some are just slow.slow.slow

Glad someone else noticed this as well...

alva is offline alva
Emperor
Republic of Flanders
Sep 2001
time: 06:36
  Old Post 01-03-2005 11:59
Edit/Delete Message Reply w/Quote
#4 Report this post to a moderator
Support Apolyton, buy Alpha Centauri

quote:
Originally posted by vovan
I'd guess that may be because it has to pull data from several different tables. It needs to get the user info from the users' table, the latest post from the posts table, etc. Also, since the user profiles are not accessed very often (not by far, as compared to, say, posts), the actualy table is probably not so well optimized, indexed, and what not.

Just my guess.

Vovan

Wouldn't it be better to drop the last post then, say you could get it from the user's profile but it wouldn't be there by default.

Skanky Burns is offline Skanky Burns
Deity
Skanky Bastard Quartermaster
Aug 2001
time: 14:36
  Old Post 01-03-2005 13:07
Edit/Delete Message Reply w/Quote
#5 Report this post to a moderator
Remove this text

Why not just be patient?

Gramphos is offline Gramphos
ACS Civ III Files Manager, Prince of Development
Chalmers, Sweden
Apr 2001
time: 06:36
  Old Post 01-03-2005 13:24
Edit/Delete Message Reply w/Quote
#6 Report this post to a moderator
Browse Apolyton AD-FREE

There are a few fields that take some time to grab. Lastpost is probably the most timeconsuming field. Since it would have to find the last post in a forum open to the viewer. Thus meaning a cross search over several tables. The time it takes probably depends on the number of posts the user has in total, since it would have to check tem all to know if they were the last post.

alva is offline alva
Emperor
Republic of Flanders
Sep 2001
time: 06:36
  Old Post 01-03-2005 18:53
Edit/Delete Message Reply w/Quote
#7 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations: Deluxe Edition

quote:
Originally posted by Skanky Burns
Why not just be patient?


* alva looks at Skanky's sig...

Nikolai is offline Nikolai
Emperor
Bergen, Norway
Oct 2000
time: 06:36
  Old Post 01-03-2005 22:31
Edit/Delete Message Reply w/Quote
#8 Report this post to a moderator
Suffering from ads?

Good one.

Shogun Gunner is offline Shogun Gunner

Emperor
Potomac Falls, Virginia
Oct 2000
time: 00:36
  Old Post 01-03-2005 22:46 Visit Shogun Gunner<br><a href=/members><img src=/forums/images/supporter-icon.gif border=0></a><BR>'s homepage!
Edit/Delete Message Reply w/Quote
#9 Report this post to a moderator
Got spare money?

I laughed at that also...

Skanky Burns is offline Skanky Burns
Deity
Skanky Bastard Quartermaster
Aug 2001
time: 14:36
  Old Post 02-03-2005 02:57
Edit/Delete Message Reply w/Quote
#10 Report this post to a moderator
Support Apolyton, buy GURPS/ Alpha Centauri

Oops.

  < Last Thread     Next Thread > Post New Thread     Post A Reply
All times are GMT. The time now is 05:36.
Apolyton Time is 00:36.
    top of page
Rate This Thread:
Forum Jump:
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
 




Contact Us - Apolyton Civilization Site - Support Us!

Building a better Apolyton through better information. Click here and take our poll!
Non-US visitors, click here!

Powered by: vBulletin Version 2.0.3
Copyright ©2000, 2001, Jelsoft Enterprises Limited.

Page generated in 0.0424 seconds (87.04% PHP - 12.96% MySQL) with 36 queries
Page Loading Time:

Support Apolyton: Amazon USA | Amazon UK | Amazon DE | Amazon FR |
Support Apolyton and get FREE PLUS, Buy from Chips&Bits: Galactic Civilizations | Galactic Civilizations: Deluxe Edition | Call to Power 2 | Civilization: The Boardgame | GURPS/ Alpha Centauri | Alpha Centauri | Civilization IV | Civilization III: Complete |


Front Page | Civilization IV | Civilization III | Civilization II | Call to Power II | Alpha Centauri | Master of Orion III
Rise of Nations | Galactic Civilizations | Galactic Civilizations II | Misc
Alt.Civs | Civ I | C:CtP I | About | News | Directory | Apolyton Store | Forums | Chat | Columns | Interviews | Newsletter
Scenario League | CSC | Clash of Civs | Spanish Site | CtP Maps | Cradle of Civ | WesW's Ctp1/2 Site | Civ3 Haven

apolyton.net | apolyton.com | civilization2.net | civilization3.net | civilization4.net | civilizationiv.info | calltopower.net | galciv.net | galciv2.net | moo3.net