Working on the spreadsheet functionality
Posted by mholmes on 15 Aug 2014 in Activity log
Spreadsheet generation is painfully slow and often runs out of memory or time. This is understandable given the number of queries taking place for complex table relationships, but I've managed to improve it substantially. I'm also working on speeding up retrieval for regular display, and I have a function written but not tested yet (db_recordList.php populateFromDb2). Ultimately, though, a massive set of joins is probably going to have to be done in the initial single query, making it absolutely huge but having it run only once, and then the non-standard db fields (lookups, one-to-manys etc.) will have to figure out parsing those results.