Search results

  1. Redoing the save/load system to use a real database.

    I have added guild data save/load functionality but I need to test it more to make sure it works. I have also optimized the save so the buffers are created in ~50ms which unfortunately still not fast enough to remove save state pauses but still pretty damn fast. I'll have to look into c#...

  2. Redoing the save/load system to use a real database.

    Just some updates, I have added some threading and buffering to the code to increase performance but its still slower than regular save/load. With a fully populated world, save times are around 2-3 seconds. Still way too slow to turn off world save pauses unfortunately so I'll have to come up...

  3. Redoing the save/load system to use a real database.

    I have uploaded my code I've done so far to git https://github.com/keninishna/ServUO-master I still need to make a sql script to generate the db and the schema for new installs but its all a work in progress anyways.

  4. Redoing the save/load system to use a real database.

    Also if anyone wants to watch, sometimes I stream http://www.twitch.tv/keninishna

  5. Redoing the save/load system to use a real database.

    Thanks, I've managed to get the world to load and save mobiles/items from the db finally, woot! so a large part of the code is done. As far as serialization goes I've added the data column to both items/mobiles but the base mobile/item classes aren't serialized its writing and pulling directly...

  6. Redoing the save/load system to use a real database.

    lol well I only had about 100 item types loaded at the time. I managed to get the type index fixed by saving the item types to its own table in the db. Now I just realized how fucked I am, lol. When items get serialized/deserialized it calls their own serialize class then passes it down so...

  7. Redoing the save/load system to use a real database.

    Well just a short update. I have managed to get mobiles to save to the dB and then also load to the world when the server loads. As my c# skills improve I am able to code faster. I have also got items writing to the dB now but I'm stuck on getting them to load. I'm too tired to keep debugging...

  8. Redoing the save/load system to use a real database.

    Well let me explain what I mean or am trying to do with the buffer decreasing world save times. From what I understand the reason the world pauses during saves is to prevent inconsistencies with multiple threads and a big ever changing world. So the world pauses and saves and lets everyone go on...

  9. Redoing the save/load system to use a real database.

    Just wanted to post a quick update on my progress. It's been slow but I'm slowly learning c# as I go along. So far I've managed to get the mobiles saved in a bulk insert which is much faster than what linq was doing. Used to take 6 seconds to save a few thousand mobiles now it takes 0.4 seconds...

  10. Redoing the save/load system to use a real database.

    Yes, I am leaving all the existing code in for the most part just adding in some if statements to switch to my code if its turned on. I'll be sure to add some command like SaveToSQL while using any save/load method. That would convert the current world to the SQL db then you could load from the...

  11. Redoing the save/load system to use a real database.

    Well after much debugging and hitting my head and cursing microsoft I managed to get the world to write the mobiles to the db. Well most properties of the mobiles there are some things I need to code in for certain things because it doesn't like integers being null. Its really slow saving though...

  12. Redoing the save/load system to use a real database.

    Yeah, that makes sense. 10k queries or 10k rows? I guess its all relative as to whats being done on the db. As far as the lazy loading goes its built into the underlying LINQ framework. What I would do is make an abstract item class that has some basic information about items such as their...

  13. Redoing the save/load system to use a real database.

    Yeah the IOs might be an issue for VPS servers. I would need to have a buffer that keeps track of the deltas and send that over to the db every so often. I'm trying to avoid whole world saves because it seems inefficient to me. But one step at a time.

  14. Redoing the save/load system to use a real database.

    Yeah, I was thinking this would be the simplest way of implementing it but I feel like the whole serialization can be bypassed although it might take some restructuring of a lot of code or at least I'll try to get most of it to bypass the serialization and keep part of the data serialized. One...

  15. Redoing the save/load system to use a real database.

    I found the code in the myrunuo and it looks like its just doing manual queries to a sql db. I believe with LINQ you can model a db where you can just directly store objects in c# which will make it easier than having to type out everything that gets saved into its own sql query. I have a few...

  16. Redoing the save/load system to use a real database.

    Hi all, I'm learning c# and decided this would be a good project to do it. Right now analyzing the code, ServUO uses a very complex serialization system to save and load the world states. At first I was thinking of using a object oriented database like db4o...

  17. [Request] Can anyone create a tutorial to host on cloud?

    oi mate! you can get a cheap vps http://lowendbox.com/ and load servuo on there, doesn't need to be directly where you are but usually the closer the faster the internet connection.
View older results

Active Shards

Donations

Total amount
$0.00
Goal
$500.00
View
Back