Built in Database - RunUO

aventae · 02-04-2008, 06:33 AM

Just a thought for a built in database that can import microsoft access files or excel.

or a version of RunUo with one built in. Possibly an option to be able to switch between the built in database or using odbc connector to one.

that-was-easy · 02-25-2008, 08:12 PM

Excell/access would be slow. But what would be neat is mysql or evne mssql (though mysql would be better as its free). Would be a huge project but if done properly would make RunUO VERY scalable, and not require such a high end server for lot of item/mobs. Trick is each different item would get its own table. So lets say baseweapon, would be something like: int32 serial, int32 cliloc, varchar255 name, int32 damageincrease, int32 hci, and so on (would be rather huge table) The tricky part would be those items like spawners which store arrays. But it could be done if well thought out. also you don't save the entire thing, you only save what changes. In fact you could write to memory then commit to the DB pretty much right away.

Brutus5000 · 04-06-2008, 05:00 PM

Quote:

Originally Posted by Ryan

Courageous is actually right here... we did a lot of tests on saving to MySQL and SQL Server and both were significantly slower than saving to a flat file. Now that's not to say that RunUO couldn't be improved to take advantage of MySQL and have a faster save mechanism but it would require a lot of re-design.

The accounting system in MySQL is kind of "old hat" we've been doing that for a while and it's not something that's really "simple" to maintain hence why we have not publicly released it.

Either way there's a lot of cool things we've done with MySQL... we've moved all command logging, full blown speech logging and what have you to MySQL. UOGamers Hybrid does about 40 - 60 million lines of text per day depending on the day of the week so you can imagine the sheer volume of MySQL transactions that generates.

I have a feeling in the coming months you could see an "Advanced" RunUO released that could have some MySQL toys

Ryan

Taken from here

This statement is nearly one year old, but I still hope it will be released someday.

02-04-2008, 06:33 AM	#1 (permalink)
aventae Forum Expert Join Date: Aug 2003 Age: 32 Posts: 388	Built in Database Just a thought for a built in database that can import microsoft access files or excel. or a version of RunUo with one built in. Possibly an option to be able to switch between the built in database or using odbc connector to one.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

02-25-2008, 08:12 PM	#2 (permalink)
that-was-easy Account Terminated Join Date: Feb 2008 Posts: 1	Excell/access would be slow. But what would be neat is mysql or evne mssql (though mysql would be better as its free). Would be a huge project but if done properly would make RunUO VERY scalable, and not require such a high end server for lot of item/mobs. Trick is each different item would get its own table. So lets say baseweapon, would be something like: int32 serial, int32 cliloc, varchar255 name, int32 damageincrease, int32 hci, and so on (would be rather huge table) The tricky part would be those items like spawners which store arrays. But it could be done if well thought out. also you don't save the entire thing, you only save what changes. In fact you could write to memory then commit to the DB pretty much right away.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)