C# mysql *drull*

Anything regarding UO or Age of Valor
Locked
User avatar
Red Squirrel
Posts: 29209
Joined: Wed Dec 18, 2002 12:14 am
Location: Northern Ontario
Contact:

C# mysql *drull*

Post by Red Squirrel »

I'm at work and was researching what is involved in a MsSQL2000 to 2005 migration and got bored from constantly running into the same article over and over, its one where you read 2 paragraphs and have to pay IRL money to read the rest. F*** that. So I drifted off into researching C# mysql implementation and it looks rather slick. Once all ML is coded I'll definitely be looking into coding RunUO to use Mysql and dump the whole serialization thing. This would be a huge overhaul of the entire core and probably all files too.

This would lead to unlimited possibilities in terms of web interfaces, would totally illiminate the need to save EVERYTHING at once at certain intervals, would be way faster overall, and more reliable. The vanishing item issue would most likely be gone as well.

About the only world saves we'd have is having to save locations of mobiles but the rest would save in real time as it could run update/insert queries on the fly. These saves would probably be in the background too. If I can figure multi threading the mysql stuff in general would be done in background. This would sooo rock. Just think of the scalability.

Archived topic from AOV, old topic ID:915, old post ID:6034
Honk if you love Jesus, text if you want to meet Him!
User avatar
Death
Posts: 7919
Joined: Thu Sep 30, 2004 10:12 pm

C# mysql *drull*

Post by Death »

Red Squirrel wrote:I'm at work and was researching what is involved in a MsSQL2000 to 2005 migration and got bored from constantly running into the same article over and over, its one where you read 2 paragraphs and have to pay IRL money to read the rest. F*** that. So I drifted off into researching C# mysql implementation and it looks rather slick. Once all ML is coded I'll definitely be looking into coding RunUO to use Mysql and dump the whole serialization thing. This would be a huge overhaul of the entire core and probably all files too.

This would lead to unlimited possibilities in terms of web interfaces, would totally illiminate the need to save EVERYTHING at once at certain intervals, would be way faster overall, and more reliable. The vanishing item issue would most likely be gone as well.

About the only world saves we'd have is having to save locations of mobiles but the rest would save in real time as it could run update/insert queries on the fly. These saves would probably be in the background too. If I can figure multi threading the mysql stuff in general would be done in background. This would sooo rock. Just think of the scalability.
That'll be one hell of a project.

Archived topic from AOV, old topic ID:915, old post ID:6035
User avatar
Red Squirrel
Posts: 29209
Joined: Wed Dec 18, 2002 12:14 am
Location: Northern Ontario
Contact:

C# mysql *drull*

Post by Red Squirrel »

Oh ya. Basically every mob/item script would have to be modified to accomodate the new system. Thats not even considering coding that system. :P

Archived topic from AOV, old topic ID:915, old post ID:6040
Honk if you love Jesus, text if you want to meet Him!
Locked