Server Load Issues

[tekrice]

How much bandwith does the DB connectivity use up on a server? if I wanna use NWNX to see players online, stats, etc? Like how much of a burden does it put on a server???

[NoMercy]

If your running MySQL for example on the same server, it doesn't take up any bandwidth. The load requirements on the server depend on the ammount of data you store and how you store it, using the tables and functions inclued in the ODBC distribution should require very little processing time.

SQL like any programming language can do some stupid things which will clog up the CPU something horrid, but if your working on limmited data sets and not doing anything more than simple operations, it shouln't cause any issues at all.

[JeroenB]

All I can add here is to add some script to the OnClientEnter which stores the information about the player you are interested in in the database and when the player leaves the game remove it again with a DELETE statement.

You can then quit easily get those information from the database with PHP or any other scripting language that supports your database.

[flel]

What kind of MySQL table type would be most efficient for this kind of usage? A HEAP with a auto_increment index and a blob to store the object?

[flel]

I just tested but HEAP format does not seem to be able to support BLOB's (or TEXT's), is it possible to store PC objects in another data type?