Quote:
Perhaps PT v3 could be designed with db simplicity in mind, and move over to mysql?
MySQL... you jopke surely???
It is at least a sensible option compared to the suggestion of MS SQL Express with the 2GB RAM / 1 CPU restrictions
Without loading up on MsSQL Vs. PGSQL flamewar ammunition lol, MySQL is out because of weirdo licensing conditions... PT can not link against mysql without becoming GPL, unless fork out silly $$$$$ to license MySQL AB or something like that - I can't remember a great deal from the old PT forum threads.
Besides, I'm fairly sure RVG just demonstrated PGSQL can be plenty fast enough for a tracker app once the SQL is wrapped in transactions etc. - I still stand by my earlier statement that PT's database speed problems stem from the MS Access default / going through ODBC - I believe vast performance increases could be achieved if that was dropped for version 3, alternatively totally seperate code used to read/write different DB engines.
Would be very interesting if PT & PA-HUD abstracted the DB layer somehow (PERL maybe?), thus allowing the user to implement almost any DB backend... then we could see some seriously interesting DB performance comparisons etc.
Very much looking forward to a new generation of apps
dave.