Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Event Log Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: July 23 2005 at 10:56 | IP Logged Quote TonyNo

I've noticed that pulling up the event log via the web takes a bit of time, but once it's open, going to the first page always gives updated info and is very quick.

Is there a way to pull up only the first page and not load the data for the rest until I request it?
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: July 27 2005 at 21:00 | IP Logged Quote TonyNo

Just in case this was missed...
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: August 10 2005 at 20:51 | IP Logged Quote TonyNo

More blatently...

BUMP!
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: August 10 2005 at 21:33 | IP Logged Quote dhoward

Yikes!!

Sorry Tony, must have been snoozing. I'll look into this and get back to you.

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: August 10 2005 at 21:50 | IP Logged Quote dhoward

Tony,

I checked out the code and cant see why this would happen. The current eventlog webpage code only queries the data for the current page, even if it's the first page for the first time (IOW, it's not doing a full query and storing it anywhere).

I tried to logon as guest access to your PowerHome server and it looks like you're down .

Let me know if you've got guest access available somewhere and I'll try to check it out for myself.

Thanks,

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: August 10 2005 at 22:23 | IP Logged Quote TonyNo

Hmm.

Should be up; I just tried it and got in with guest cred's. Error message, or 404?
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: August 17 2005 at 13:58 | IP Logged Quote dhoward

Tony,

I went in the other day and was able to access it just fine...go figure.

Anyways, I tested around with the eventlog the other day and went ahead and tried again today and didnt see anything really out of the ordinary. The other day, it seemed like the initial page took a couple of seconds longer and today, every page was taking about 5 seconds from click to fully rendered.

Ive checked the code, and it is set to always pull just the necessary information using a rows between type of function. It's possible however that subsequent speed increases are merely a result of the database server caching the data from the table.

Let me know what kind of results you're getting and we'll see if this is something that needs to be looked at.

Also, let me know approx how many records you typically have in your log file and how large your database file is. You may be able to pick up some speed by rebuilding the database using the DB Util and shrinking your datafile.

Let me know,

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: August 17 2005 at 14:29 | IP Logged Quote TonyNo

OK, Dave. I think I need to compact the DB anyway. I'll leyt you know.

Tony
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum