o0 i'm not using the old driver, Solid is. I'm using latest versions of all files but i use win XP pro not 2000 server. I installed the 2005 mssql eval server and noticed a bit of a performance gain over the old 2000 eval but the system overheads were still apreciably higher than MySQL.
I think people are missing the point here, from my experience so far MySQL seems idealy suited to people who want to run a server for a small player base on a fairly low spec machine or just in loopback mode. I dont doubt that MSSQL is better for large player databases when run on a high spec box with plenty of headroom specwise but not everyone wants to run a server for 100's of players.
Personaly, i just have it rigged for my lan and use it more as a thing to experiment with and because of the subjects you have to become knowledgable in to operate it. People ask mountain climbers why they climb Everest, " 'Cos it's there" is the answer they get. Why do i want to try an get EI to work with MySQL? Because MIRSQL does and for the hell of it.
Now instead of putting a downer on the subject, and rubbishing the idea of using MySQL, why not try and add to the solution and offer some ideas not critisisms. Its not like there's much happening in the MIRSQL dept while we wait for the next version of the server exe's to come back from the Chinese is it. At least the EI server files arnt protected like the MIRSQL ones and can be ripped out. Unfortunatley for me I dont have Delphi under my resume but im pretty sure theres a few members here who do and a quick Blast with DeDe might yield some info. Auron, you've said above that both servers use the Wemade SQL libs, by that token then as MIRSQL is working then so EI could be made to also. Its just a matter of who can crack it. In this case, if i was in the MSSQL camp, i for one wouldnt mind if i was proved wrong and MySQL turned out to be a good alternative.
Just for the record my specs are
Game Server ~ XP2100 1gig ddr ram Xp pro SP2
Client ~ ditto GameServer
SQL server ~ 1.4 tbird 512 ram Xp Pro SP2 *edit* ditched XP for 2003 server ent now
Gateway ~ Old Celeron 333 128 pc100 running Clark Connect 2.1 Linux Distro
With that i still notice massive performance improvements with MySQL over MSSQL running MIRSQL localy. Although i dont have the dreaded DBwait errors that some have, Performance of EI isnt what i would like and i'm sure could be better.
I think this "spam" is more worthy that the "where can i get EI/Mir server files" or "how do i make a server?" posts normaly in here and just like MySQL/MIRSQL has been why not try and get it working or arn't you all up to for the chalenge? Sorry but theres no such thing as "cant be done" when it comes to this, it should be more like "its not going to be easy, but...." After all, everyone said before that MIRSQL wouldnt work with MySQL just like once upon a time a man said the world was round and the earth revolved around the sun and he was laughed at.
BTW is there a guide/post on streamlining MSSQL to the absolute minimum for MSSQL? i tried searching for relevant info but cant seem to find the right keyword. I know to set priority higher etc but are there any MSSQL specific tweaks that can be made to improve things in the meantime?