Working on the spreadsheet functionality

15/08/14

Permalink 03:40:44 pm, by mholmes, 105 words, 382 views   English (CA)
Categories: Activity log; Mins. worked: 300

Working on the spreadsheet functionality

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.

Pingbacks:

No Pingbacks for this post yet...

Adaptive Database

This project aims to design a flexible online database which can be set up as very quickly for a researcher requiring a relational database, and is easy to modify and extend. The Web GUI provides tools for data-entry in as simple and convenient a manner as possible, while also allowing data-integrity checks. The application development sandbox is currently at https://hcmc.uvic.ca/people/martin/potluck/editor/index.php; and half a dozen UVic projects are already using the codebase. The code is managed through SVN here: https://revision.hcmc.uvic.ca/svn/adaptivedb/.

Reports

XML Feeds