TheGamesDB.net - Open Video Game Database (wiki-based, register and contribute)
#61
malte - Some level of sleeping between requests would be most helpful. I haven't performed any load testing, so I can't say how much load the server can take. We can also look at offering a semi-static xml file with all the games for each platform for a one time mass download. I can schedule a job to refresh the files on a nightly basis.

I also wanted to let you know that there might be an xml structure change because of the multi-language request. The problem that I am facing is that each release is a separate game record. What that means is if someone adds a second or third language to a European release of game, it would not (automatically) be added to the US release of that game. The same goes for text updates. I'm kicking around the idea of consolidating multiple regional releases of the same game into one parent record and then breaking out regional differences in child records. This would only apply to the same game on a single platform released across different regions. The data would look something like this:

Top Level: Game Title (multi-language), Short Description (multi-language), Long Description (multi-language), Platform, Publisher, Genre, Players, Image, Fanart

Regional Level: Game Title, Region, Rating, Release Date, Original Price, Box Art

As for the XML, there would be an additional <Releases></Releases> node that would contain the regional level information listed above. Some of the elements from the current <Game></Game> node would move down into there.

This has been the only way I can figure out to share multi-lang data between games. I might have to go this route depending on how the CRC value question is answered. What do you all think?

Flomaster - Finally! I've been chasing the bug for a while. I think I know what the issue is but it might take me a bit to fix it. You should only get bug while sorting or moving through search result pages.
http://thevideogamedb.com - Site Creator and Admin
Reply


Messages In This Thread
[No subject] - by spiff - 2010-06-09, 13:48
[No subject] - by jas8340 - 2010-06-09, 13:50
[No subject] - by jas8340 - 2010-06-11, 23:09
[No subject] - by Maxoo - 2010-06-11, 23:20
[No subject] - by jas8340 - 2010-06-11, 23:41
[No subject] - by jas8340 - 2010-06-13, 15:18
[No subject] - by Maxoo - 2010-06-13, 17:04
[No subject] - by jas8340 - 2010-06-13, 17:32
[No subject] - by jas8340 - 2010-06-18, 22:11
[No subject] - by Errorist - 2010-06-22, 09:54
[No subject] - by malte - 2010-06-22, 16:22
[No subject] - by spiff - 2010-06-22, 16:27
[No subject] - by wimpy - 2010-06-22, 20:29
[No subject] - by jas8340 - 2010-06-23, 03:51
[No subject] - by jas8340 - 2010-06-24, 19:09
[No subject] - by jas8340 - 2010-06-26, 22:36
[No subject] - by malte - 2010-06-27, 00:08
[No subject] - by wimpy - 2010-06-27, 18:14
[No subject] - by wimpy - 2010-06-27, 18:17
[No subject] - by jas8340 - 2010-06-28, 15:19
[No subject] - by wimpy - 2010-06-28, 15:42
[No subject] - by wimpy - 2010-06-28, 15:49
[No subject] - by wimpy - 2010-06-28, 15:54
[No subject] - by wimpy - 2010-06-28, 23:12
[No subject] - by jas8340 - 2010-06-29, 21:13
[No subject] - by jas8340 - 2010-06-30, 15:55
[No subject] - by tvdb-scott - 2010-06-30, 23:25
[No subject] - by wimpy - 2010-06-30, 23:29
[No subject] - by jas8340 - 2010-07-01, 16:33
[No subject] - by wimpy - 2010-07-01, 22:29
[No subject] - by jas8340 - 2010-07-03, 15:44
[No subject] - by jas8340 - 2010-07-17, 02:33
[No subject] - by jas8340 - 2010-08-27, 14:33
[No subject] - by jas8340 - 2010-08-29, 03:54
[No subject] - by bionic1234 - 2010-08-29, 12:55
[No subject] - by malte - 2010-08-29, 19:37
[No subject] - by jas8340 - 2010-08-30, 14:31
[No subject] - by malte - 2010-08-30, 17:18
[No subject] - by malte - 2010-08-30, 17:27
[No subject] - by jas8340 - 2010-08-31, 16:29
[No subject] - by spiff - 2010-08-31, 16:34
[No subject] - by malte - 2010-08-31, 20:46
[No subject] - by jas8340 - 2010-08-31, 22:01
[No subject] - by malte - 2010-08-31, 22:27
[No subject] - by spiff - 2010-09-01, 10:48
[No subject] - by wimpy - 2010-09-01, 17:40
[No subject] - by jas8340 - 2010-09-01, 21:23
[No subject] - by spiff - 2010-09-03, 15:01
[No subject] - by jas8340 - 2010-09-03, 23:34
[No subject] - by malte - 2010-09-04, 08:21
[No subject] - by jas8340 - 2010-09-04, 14:28
[No subject] - by malte - 2010-09-04, 18:47
[No subject] - by jas8340 - 2010-09-05, 14:46
[No subject] - by spiff - 2010-09-06, 10:50
[No subject] - by jas8340 - 2010-09-08, 00:09
[No subject] - by malte - 2010-09-08, 07:33
[No subject] - by jas8340 - 2010-09-12, 16:13
[No subject] - by malte - 2010-09-14, 20:23
[No subject] - by Flomaster - 2010-09-14, 20:35
[No subject] - by jas8340 - 2010-09-14, 21:12
[No subject] - by malte - 2010-09-15, 20:38
[No subject] - by wimpy - 2010-09-16, 18:54
[No subject] - by bionic1234 - 2010-09-17, 02:28
[No subject] - by jas8340 - 2010-09-22, 17:10
[No subject] - by malte - 2010-09-24, 06:36
[No subject] - by jas8340 - 2010-09-30, 02:10
[No subject] - by marjanovich - 2010-09-30, 22:18
[No subject] - by malte - 2010-10-08, 20:52
[No subject] - by jas8340 - 2010-10-12, 15:50
[No subject] - by starcitysecrets - 2010-10-12, 16:23
[No subject] - by jas8340 - 2010-10-14, 22:01
[No subject] - by malte - 2010-10-16, 12:34
[No subject] - by wimpy - 2010-10-21, 00:35
[No subject] - by filigran - 2010-10-23, 14:16
[No subject] - by jas8340 - 2010-10-27, 01:44
[No subject] - by filigran - 2010-10-27, 02:44
[No subject] - by malte - 2010-10-27, 12:28
[No subject] - by jas8340 - 2010-11-17, 20:21
[No subject] - by filigran - 2010-11-18, 11:14
[No subject] - by jas8340 - 2010-12-02, 16:13
[No subject] - by malte - 2010-12-02, 18:37
[No subject] - by wimpy - 2010-12-02, 21:14
[No subject] - by malte - 2010-12-19, 20:21
[No subject] - by pcvii - 2010-12-21, 18:17
[No subject] - by VictorV - 2011-10-03, 01:32
[No subject] - by malte - 2011-10-04, 16:57
Logout Mark Read Team Forum Stats Members Help
TheGamesDB.net - Open Video Game Database (wiki-based, register and contribute)4