Zugg Software :: View topic

Beginner Joined: 21 Oct 2003 Posts: 15

Im having problems reducing my 23MB mdb map file...I've dloaded all the MDAC and JET updates...tryed the repair utility...it gets it down to 20MB or so...try compact database in zMAPPER and does nothing...

Do i need windows XP Service Pack 1 for MDAC and JET to have any impact?

Any suggestions? thanks

SubAdmin Joined: 18 Nov 2001 Posts: 5182

XP service pack 1 includes updates for MDAC and JET compared to XP's baseline. Since you have already gotten those updates seperately you have versions more current than those in SP1.

Compacting the database only removes garbage left over in it from record deletions and changes. If each of your rooms has an average of 300 bytes of description and name, plus 2 exits averaging 40 bytes, then that means that 3 rooms is roughly 1K, 3000 rooms roughly 1M. So how many rooms does the map actually have?

Beginner Joined: 21 Oct 2003 Posts: 15

ummm not sure how to check how many rooms....

I think i need someone on here to let me send them the .map file and see how big the mdb is for them

Novice Joined: 25 May 2003 Posts: 37

well .. I've mapped 1928 rooms (guess 10%-20% or our mud) and my .mdb is 3012 KB now.

that means 1562 bytes/room as average.

the most room descripions are not longer than 10 lines (=80 chars * 10 lines = 800 bytes)
take a look at the "ObjectTbl"-Table!
Every room has a bunch of overhead information, like coordinates, color, exits, userstr, roomname, several flags, refnmber, cost, metaid, label, two date fields (added/modified) ..... etc.
So you need probably 500-800 bytes for an empty room :)

Beginner Joined: 21 Oct 2003 Posts: 15

where do i check ObjectTbl?

Novice Joined: 25 May 2003 Posts: 37

You need a database tool like "Microsoft Access" or "Microsoft Query" to look into the .mdb :)

Beginner Joined: 21 Oct 2003 Posts: 15

i have MS 97....i try to open a map mdb file...and sais "Unrecognised database format"

Novice Joined: 25 May 2003 Posts: 37

no, MS97 is too old .. guess you'll need Office 2000/XP .. or just use any other DB-Query tool with MS-OBCD which must be installed on your system, cause I think Zmud uses it also

Beginner Joined: 21 Oct 2003 Posts: 15

can you check in zMapper how many rooms you have?

Novice Joined: 25 May 2003 Posts: 37

dont think so .. you can see the map as spreadsheet, but you can't see how many rooms it actually has .. unsless you count your rooms by hand. Because the NumberID is not equal to Room-Count. NumberID is unique so it's incremented even if you delete rooms.

just download MS-Query (which should be free), open your .mdb and execute following query to find out how many rooms you actually have:

SELECT Count(ObIid) FROM ObjectTbl;

edit: sorry the correct line is:

SELECT Count(ObjId) FROM ObjectTbl;

Beginner Joined: 21 Oct 2003 Posts: 15

heres the number of rooms in the map (or near enough) 26336

is this the reason i have a 23MB map?

Novice Joined: 25 May 2003 Posts: 37

yes

Beginner Joined: 21 Oct 2003 Posts: 15

great is it because of the number of rooms or?

Novice Joined: 25 May 2003 Posts: 37

yes .. look: 10 lines per room gives 800 byte as room description + overhead information = 1KB/room (it's the worst case)
now, 20000 rooms would take 20 MB :) if you don't compress anything

but tell me: what's the problmem with having 23 MB big file? .. is your harddisk that tiny??

Beginner Joined: 21 Oct 2003 Posts: 15

ummm no...on 6.40....map takes ages to slow...then computer and zmud is slow as...takes 15 seconds for a speedwalk to execute.......Page File in performance is over 400MB

Novice Joined: 25 May 2003 Posts: 37

I don't know if it would help, but you could try to split your map in different Zones.
I dunno the way zmud queries the database nor what algorithm it uses to find the shortest way, but I think that zones might be helpful.
BUT Compressing your map won't help here, because you'll need even more computing power and memory to decompress the map, before using it.
I'm not a Zmud expert but usuually it works that way.

GURU Joined: 28 Sep 2000 Posts: 434 Location: USA

There is a new public version (7.0!) of zMUD due out soon. It fixes the speed problems that plague the current version of zMUD. If you can't wait, you can head on over to the beta forum and try the latest beta (6.63). It, however, is experiencing some problems with speedwalking, but that should be fixed in the next beta.

If you do decided to try out *any* beta, remember to always make backups of your settings file and your map database incase something were to go horribly wrong [}:)]