Table structure
Ok, I need some advice with how to structure a table to handle the specific sets of data that is going to automatically be inputted (and outputted)
Here we go...
I have a script that reads xml data into HMTL formatted tables, and am going to convert it to use a database.
The data that is recieved is as follows:
Game ID, Game Title, Game Link
and also got moer data up to 16 times depending on the amount of player playing:
Rank, GT (name), score, kills, deaths, assists
Basically I need suggestions on a way that this can be stored into a database, and be recieved from the database. My problem is that there is a large amount of records put into the database with the current way that I am doing it, and that is
Table 1 - Games - Game id (unique), title, link
Table 2 - Playas - Game id (not unique), name, score, kills, deaths, assists.
But then the problem comes when I try to group the data, the everything from table 1, playas needs to be grouped by the game ID from table 1, games.
Hopefully leaving with a neatly layed out table on output, ordered by rank, secondary order on score, tertiary on kills, assists.
If you do not get it, I can elaborate more 😉
Thanks in advance if you can provide me with suggestions on how to go about it.
(There is also a bit of lag when inputting so many values into the tables at once, is there any way to loosen this up a bit?)
