custom created .mdb game database loads very slowly

[nxmehta]

Hi there,

I created my own .mdb game database using Access, and I'm noticing that when I load up the games list that references this db, it loads very very slowly. It takes several seconds for the game list to load, whereas other, larger .mdb's load almost instantly. This can be annoying because even when the game list is first loaded, when I select a game, and then go back to the games list, it takes several seconds again for it to load.

It does appear from the logs that GameEx is using a cache for the database (and I see the dbcache file in the DATA dir), so I'm not sure why things are so slow. Can one of you db gurus maybe take a look at this and tell me what might be going wrong? I've attached the mdb file (zipped) and my GameEx log.

Thanks.

dos.mdb.zip

log.txt

GameEx.ini

[Draco1962]

Can you please attach a copy of your GameEx.ini file? Thanks!

[nxmehta]

Can you please attach a copy of your GameEx.ini file? Thanks!

Okay, i added the ini.

[Draco1962]

I extracted what I was looking for (your emulator setup for the DOS - Role Playing Games:

[Emulator_32]

DATABASE=DOS - Role-Playing

Enabled=True

STARTPAGENAME=[PC] DOS - Role-Playing

TITLETEXT=DOS Role-Playing

StartPageLogo=Microsoft DOS

WorkingPath=C:\Program Files (x86)\GameEx\EMULATORS\DOSBox

RomPath=G:\(DOS)\Role-Playing\Games\Games

ROMFilter=*.bat

Command=start /wait cmd.exe /c "G: & cd "[ROMPATH]" & "[ROMFILE]""

SnapPath=G:\=Extras=\DOS\Snap

VideoSnapPath=

TitlePath=G:\=Extras=\DOS\Title

BoxPath=G:\=Extras=\DOS\Box

CartPath=G:\=Extras=\DOS\Media

ReplaceDash=False

ReplaceUnder=False

Capitals=False

RemoveBrackets=False

ShowDesktop=True

MAPFile=C:\Program Files (x86)\GameEx\MAP FILES\DOS - Role-Playing.map

configFile=[Mapping Off] Exit (Process Close)

Debug=False

CustomBackground=

PlayMusic=False

PCGame=False

GamesIn7Zips=False

PlayInScreenSaver=False

RomsInFolders=True

ShowMostPlayed=True

RandomMostPlayed=True

PlaySelectionMusic=False

CDCheck=False

WaitBeforeKeys=

SendKeys=

ControlPanelPath=

ExcludedFiles=

ManualPath=G:\=Extras=\DOS\Manual

Nothing seems out of sorts here that I can tell. How are your game files named? When looking at your db, the name is the same from the Name, GoodName, NoIntro, and TOSEC columns. Not sure if that could contribute to the latency and I will defer to Headkaze, Tom, GreatFlash, or someone else to answer as I am not too savvy of the GameEx inner workings. Have you tried clearing out your cache files (any file with cache in the filename and/or extension)?

[nxmehta]

The games are launched by their own individual .bat files, which are named exactly as specified in the db by the Name, GoodName, NoIntro and TOSEC columns (all the same).

I have tried deleting the cache files in the DATA dir in GameEx but that doesn't seem to help.