{"id":4598,"date":"2017-01-15T23:55:23","date_gmt":"2017-01-15T23:55:23","guid":{"rendered":"http:\/\/phoenixgamedevelopment.com\/blog\/?p=4598"},"modified":"2017-01-16T00:38:00","modified_gmt":"2017-01-16T00:38:00","slug":"p0-p-172-part-89-server-architecture-data-paging","status":"publish","type":"post","link":"https:\/\/phoenixgamedevelopment.com\/blog\/p0-p-172-part-89-server-architecture-data-paging\/","title":{"rendered":"P0-P-172: Part 89: Server Architecture, Data Paging"},"content":{"rendered":"

I have had to reconsider my entire server architecture in light of the recent problems that I have been having.<\/p>\n

Up to now, I have been working with (successful) concepts tests, but now I need to actually use the database for the next step of the project.<\/p>\n

I have found that the current system cannot reliably handle the quantity of data that is being sent, even if I don’t use raw serialisation.<\/p>\n

I have been looking into a few different architectures in an attempt to speed things up, and I think that I may actually add all of the database code to the unity game server, cutting out my c# server entirely.<\/p>\n

Obviously, I would not add any mysql code to the client, however, the (unity) clients would connect to a unity gameserver, which would in turn connect directly to the mysql database.<\/p>\n

Adding mysql support to unity directly is proving to be extremely difficult though, I need to find a mysql dll which is compatible with the .NET\u00a0framework that unity uses.<\/p>\n

\"Unity<\/a>
Unity
10\/01\/2017 , 06:13:16 AM
Unity Personal (64bit) – P0Main.unity – New Unity Project – PC, Mac & Linux Standalone<\/figcaption><\/figure>\n
\"Unity<\/a>
Unity
10\/01\/2017 , 06:13:53 AM<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

I have had to reconsider my entire server architecture in light of the recent problems that I have been having. Up to now, I have been working with (successful) concepts tests, but now I need to actually use the database for the next step of the project. I have found that the current system cannot […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,17,10,11],"tags":[],"class_list":["post-4598","post","type-post","status-publish","format-standard","hentry","category-astral-realms","category-p-0","category-software-and-games","category-spiritus-astrum","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"builder_content":"","_links":{"self":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts\/4598"}],"collection":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/comments?post=4598"}],"version-history":[{"count":4,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts\/4598\/revisions"}],"predecessor-version":[{"id":4609,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts\/4598\/revisions\/4609"}],"wp:attachment":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/media?parent=4598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/categories?post=4598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/tags?post=4598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}