sql on 2.6

Join Discord

Bon

Legend
Legendary
Jul 29, 2004
6,726
330
300
Kent, UK
why use SQL? uses loads of resources, and all SQL is used for is loadin the mobs etc.... ur better off usin access
 
Upvote 0

Weikster

LOMCN Veteran
Veteran
Jan 21, 2009
421
11
44
36th chamber
It can be if its coded to? Dunno about the files that you are using..
AND please, SQL > Access.
Access 2000 has many restrictions in comparison with SQL Server 2000 and cannot be used in the case you want to build stable and efficient system with many concurrent users.
If you need to make a scalability, security, and robustness system, you should use SQL Server instead of Access. Because Access 2000 does not support atomic transactions, it does not guarantee that all changes performed within a transaction boundary are committed or rolled back. SQL Server is integrated with Windows NT security, but Access is not. Access 2000 databases cannot be restored to the point of failure, when SQL Server databases can be.

Access 2000 database is only sufficient when you need to store a small amount of data in a single user (or few users) environment, or when you have very low resources, such as memory or disk. In other case, use MSDE or SQL Server.

And with everyone thinking they need a dual/quad core, 4-8gig ram machine to host mir, then sql most definatley.
 
Last edited:
Upvote 0

Hany

Golden Oldie
Golden Oldie
Feb 28, 2005
886
32
135
Maybe access>sql, sql>access dont know..but i find access is much easier.

On topic yeh if ur files coded for sql then it can be used.
 
Upvote 0

Celsius

LOMCN Veteran
Veteran
Dec 31, 2008
1,155
17
124
It can be if its coded to? Dunno about the files that you are using..
AND please, SQL > Access.
Access 2000 has many restrictions in comparison with SQL Server 2000 and cannot be used in the case you want to build stable and efficient system with many concurrent users.
If you need to make a scalability, security, and robustness system, you should use SQL Server instead of Access. Because Access 2000 does not support atomic transactions, it does not guarantee that all changes performed within a transaction boundary are committed or rolled back. SQL Server is integrated with Windows NT security, but Access is not. Access 2000 databases cannot be restored to the point of failure, when SQL Server databases can be.

Access 2000 database is only sufficient when you need to store a small amount of data in a single user (or few users) environment, or when you have very low resources, such as memory or disk. In other case, use MSDE or SQL Server.

And with everyone thinking they need a dual/quad core, 4-8gig ram machine to host mir, then sql most definatley.
The 2.6 files only use Access to store things such as items, mobs, magics etc etc which are only loaded once when you server is started up.

Everything to do with characters and accounts uses paradox, .db, which I find to be far more stable than sql.

Btw, nice copy and paste.
 
Last edited:
Upvote 0