Author |
|
TonyNo Moderator Group
Joined: December 05 2001 Location: United States
Online Status: Offline Posts: 2889
|
Posted: July 23 2005 at 10:56 | IP Logged
|
|
|
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 |
|
|
TonyNo Moderator Group
Joined: December 05 2001 Location: United States
Online Status: Offline Posts: 2889
|
Posted: July 27 2005 at 21:00 | IP Logged
|
|
|
Just in case this was missed...
|
Back to Top |
|
|
TonyNo Moderator Group
Joined: December 05 2001 Location: United States
Online Status: Offline Posts: 2889
|
Posted: August 10 2005 at 20:51 | IP Logged
|
|
|
More blatently...
BUMP!
|
Back to Top |
|
|
dhoward Admin Group
Joined: June 29 2001 Location: United States
Online Status: Offline Posts: 4447
|
Posted: August 10 2005 at 21:33 | IP Logged
|
|
|
Yikes!!
Sorry Tony, must have been snoozing. I'll look into this and get back to you.
Dave.
|
Back to Top |
|
|
dhoward Admin Group
Joined: June 29 2001 Location: United States
Online Status: Offline Posts: 4447
|
Posted: August 10 2005 at 21:50 | IP Logged
|
|
|
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 |
|
|
TonyNo Moderator Group
Joined: December 05 2001 Location: United States
Online Status: Offline Posts: 2889
|
Posted: August 10 2005 at 22:23 | IP Logged
|
|
|
Hmm.
Should be up; I just tried it and got in with guest cred's. Error message, or 404?
|
Back to Top |
|
|
dhoward Admin Group
Joined: June 29 2001 Location: United States
Online Status: Offline Posts: 4447
|
Posted: August 17 2005 at 13:58 | IP Logged
|
|
|
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 |
|
|
TonyNo Moderator Group
Joined: December 05 2001 Location: United States
Online Status: Offline Posts: 2889
|
Posted: August 17 2005 at 14:29 | IP Logged
|
|
|
OK, Dave. I think I need to compact the DB anyway. I'll leyt you know.
Tony
|
Back to Top |
|
|