[Home] [Downloads] [Search] [Help/forum]

Gammon Software Solutions forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

[Folder]  Entire forum
-> [Folder]  MUSHclient
. -> [Folder]  General
. . -> [Subject]  Database is lagging!
Home  |  Users  |  Search  |  FAQ
Username:
Register forum user name
Password:
Forgotten password?
Database is lagging!

[Reply to this subject]  Reply to this subject   [New subject]  Start a new subject   [Refresh] Refresh page

Posted by 99fender   (13 posts)  [Biography] bio
Date Tue 01 Apr 2003 11:21 PM (UTC)  [ quote  ]
Message
Hey,

I got a problem with my MUSHClient. I have about 10 worlds running a computer in MUSHClient on PerlScript.

They are all linked to a main .db file. I have two computers, one is 1.4ghz 128mb RAM, the other is 200mhz 128mb RAM. I bought the second one mainly to keep the 10 worlds up all the time.

The computer itself is fine and quite fast, even the MUSHClient bots are fine themselves. But, when it comes to anything .db linked - it really lags. For instance, one of the Bots would search for a record in the DB and it would freeze mushclient for 5 seconds-odd and then come up with the result again.

This never happened on my 1.4ghz - How can i fix this! (I also had an old 75mhz testing them out for 2 days - this had less lag when it came to the database!!)

Thanx
[Go to top] top
Posted by Nick Gammon   Australia  (18,770 posts)  [Biography] bio   Forum Administrator
Date Reply #1 on Wed 02 Apr 2003 07:08 AM (UTC)  [ quote  ]
Message
Can you explain about the .db file a bit more? Is this an Access database using the database plugin, or something else?
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by 99fender   (13 posts)  [Biography] bio
Date Reply #2 on Wed 02 Apr 2003 08:40 AM (UTC)  [ quote  ]
Message
Erm.. Im not entirely sure, all I know is that - when you open it in word pad, its ALL just text with many spaces between different bits of data. And it's 1000's of lines long..

I edit it in notepad or through MUSH if I ever have to..

It's never been slow accessing it before, just is now.

The .db is a very big one by the way.
[Go to top] top
Posted by Nick Gammon   Australia  (18,770 posts)  [Biography] bio   Forum Administrator
Date Reply #3 on Wed 02 Apr 2003 11:32 PM (UTC)  [ quote  ]
Message
This isn't really a MUSHclient problem - it is based on a script that accesses a very large file.

For a start, you say you have gone from a 1.4 GHz PC to a 200 MHz one. That is 7 times as slow, so you will certainly notice a difference on compute-bound applications.

I am not surprised that a Perl script that scans a text files that is thousands of lines long takes a few seconds. However if you had less lag on your 75 MHz PC then maybe it is a configuration issue. Maybe a different version of Perl, or some other thing like that.

You could try rewriting the database to use a "real" database, there are some examples on this site of using Access databases, or you could use mySQL with a bit more work. This would reduce the need for linear scans of a very large file.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by 99fender   (13 posts)  [Biography] bio
Date Reply #4 on Thu 03 Apr 2003 10:35 AM (UTC)  [ quote  ]
Message
Nick,

http://www.gammon.com.au/forum/bbshowpost.php?bbsubject_id=38

Perhaps my issue could be related to that? Any suggestions?
[Go to top] top
Posted by Nick Gammon   Australia  (18,770 posts)  [Biography] bio   Forum Administrator
Date Reply #5 on Thu 03 Apr 2003 10:54 AM (UTC)  [ quote  ]
Message
Could be, hard to say without seeing your triggers.

Go into the configuration screens, "info" sub-screen, and see how much time (in seconds) the triggers have taken. If it is a lot for newly-opened world (eg. more than a few seconds), then look at individual triggers. Each one will list its execution time. If you find one that seems grossly more than the others (eg. most take 0.05 seconds, one takes 20 seconds) then take a close look at that one.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by 99fender   (13 posts)  [Biography] bio
Date Reply #6 on Thu 03 Apr 2003 11:05 AM (UTC)  [ quote  ]
Message
Nick!

How do you find individual execution time?!

Thanx
[Go to top] top
Posted by Nick Gammon   Australia  (18,770 posts)  [Biography] bio   Forum Administrator
Date Reply #7 on Thu 03 Apr 2003 11:48 AM (UTC)  [ quote  ]
Message
Edit the trigger, the time it has taken to execute (and the number of executions) are on the dialog in the middle somewhere.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

2,738 views.

[Reply to this subject]  Reply to this subject   [New subject]  Start a new subject   [Refresh] Refresh page

Go to topic:           Search the forum

[Go to top] top

[Home]

Written by Nick Gammon - 5K

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( http://www.gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Internet Contents Rating Association (ICRA) - 2K]    [Web site powered by FutureQuest.Net]