TunerZ (a project in development)

[Angelo]

Okay, I just wanted to know for sure.

Thanks for the replies, now I can finally continue my server with a good feeling, that I'm not doing something wrong.
Thanks.

[FNX]

Microsoft, I think it's the most userfriendly and easiest database.

:lol:

You should try MySQL my friend

[JSoftware]

Microsoft, I think it's the most userfriendly and easiest database.

:lol:

You should try MySQL my friend

MySQL is horrible on a windows box. To do anything worthwhile with it you would still have to use it through ADO or ODBC. Userfriendliness is pretty bad also.

I haven't tried MSSQL though, but I would presume it atleast has an official visual GUI

[FNX]

[OT mode on]

Well i used it for many years now, with direct access both by Java and Delphi with no problems at all. It used to be tricky before MySQL 5 but
is a great option from that release on. One of the biggest game portals in
Italy (alive and working) i worked on is based on MySQL 5

[OT mode off]

The important thing is that we wait to see this game working!

[technomage]

I have to agree, I use MS SQL (2000 and 2005) every day, and I find MySQL allot easiers to work with it's also a little more consistent, with MS SQL, you have to do some real messing around to get things working really fast.

[savage]

I was going to suggest MySQL as well. MS SQL Server has better UI interface to the DB, but for speed and robustness I would look at MySQL and switch to the Unix based OS.

[Setharian]

I guess you are using windows in which case your only realistic option would be to use threads. I don't think that asynchronous operation would be realistic on a scale like that.

wrong, asynchronous operations allow tenths of thousands of simulatnous connections using only a few threads (user-spawned threads, kernel may spawn more threads to handle the requests but those are hidden)...never heard of I/O Completion Ports? you just associate a handle (or a socket) with a completion port (that is you may associate hundreds of handles/sockets with the same completion port), issue a thread to wait for a completion packet to be enqueued in the port's queue and when one or more entries are enqueued, the thread is awoken, completion packet is dequeued and you know what sort of event has happened your description matches definition of a MMO game and under windows IOCP is the way, under linux epoll, under freebsd kqueue elsewhere threads or fork

[JSoftware]

Oh, I thought of asynchronous sockets as being handled by the message queue of the main window handle alone. I've never looked into IOCP before but I certainly will now

[Angelo]

The important thing is that we wait to see this game working!

I'm working almost 24/7 on it, so doing the best I can
Altho, this project will be huge for me, I've planned the release for in 2008.
So, just to let you know, it will take a while.

I must start organise things, this can not continue any longer.
Now I'm working on the physics (on a standalone) while I know the server must be right first.
So, at this moment I'm creating a schedule, a tight schedule.
When and what should be finished, I'll keep everyone up-to-date with this thread.

I was going to suggest MySQL as well. MS SQL Server has better UI interface to the DB, but for speed and robustness I would look at MySQL and switch to the Unix based OS.

Thanks for the advice (everyone that adviced MySQL) I'll certainly take a look at it.
I only use MySQL for PHP and I've never used it in Pascal.
What component would you suggest, or should I write one myself?!

Thanks for the enthusiasm everyone

Angelo.

[FNX]

What component would you suggest, or should I write one myself?!

Have a look to ZeosLib, i used them in Delphi but if i do remember well
they should work with other languages aswell. They are quick, stable and
opensource, so you don't have to write a driver yourself (it would take
more than to write the game itself )