Anything Forums

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

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

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

Archived topic from AOV, old topic ID:915, old post ID:6040