I had earlier modified DBman for recording computergame multiplay sessions for some 20 players. Each report has 40 fields and I ended up with some 1700 reports. I have now tried to get summaries from these reports, but the amount of info makes it impossible. Even with 500 reports it is very slow. It works quite ok when searching for one player name only, but no chance with name=* Each record is also validated before it is displayed for totals. The main idea was to be able to get summaires so the DB is not yet in use for my web site :(
example of a single player search with each record shown:
http://www.muodos.fi/cgi-bin/dbman/db.cgi?&uid=default&view_records=1&name=Jompa&stamp=88&sb1=3&so1=decend&sb2=4&so2=descend
example of a summary of all with limit of 500 records (very slow):
http://www.muodos.fi/cgi-bin/dbman/db.cgi?uid=default&view_killboard=1&stamp=88
So now I am trying to make a new database for a new game and thought of trying the JPD relative mod to read records from 2 databases... But can my users also write to 2 databases from one single report form??? ... and can the record validation be made to modify record in 2 different databases at the same time???
My idea was still to record single reports into one database but at the same time write to a summary database. Then I could get the summaries from a separate DB without having to calculate them from the original records every time.
Sorry if this kind of thing has been asked already.. I just could not find any suitable mod or mail to help me into right direction with this.
example of a single player search with each record shown:
http://www.muodos.fi/cgi-bin/dbman/db.cgi?&uid=default&view_records=1&name=Jompa&stamp=88&sb1=3&so1=decend&sb2=4&so2=descend
example of a summary of all with limit of 500 records (very slow):
http://www.muodos.fi/cgi-bin/dbman/db.cgi?uid=default&view_killboard=1&stamp=88
So now I am trying to make a new database for a new game and thought of trying the JPD relative mod to read records from 2 databases... But can my users also write to 2 databases from one single report form??? ... and can the record validation be made to modify record in 2 different databases at the same time???
My idea was still to record single reports into one database but at the same time write to a summary database. Then I could get the summaries from a separate DB without having to calculate them from the original records every time.
Sorry if this kind of thing has been asked already.. I just could not find any suitable mod or mail to help me into right direction with this.