search

johnmackintosh / patientcounter

fast, flexible patient census tables. Quickly count patients or resources by interval. No SQL, no problem.
https://johnmackintosh.github.io/patientcounter
Other
28 stars 5 forks source link

turbo version - much faster with foverlaps #4

Closed johnmackintosh closed 4 years ago

johnmackintosh commented 4 years ago

removed the sequence creation. Using foverlaps - some changes still to be made e.g. polish up what is returned at patient level.

individual records by patient by 15 mins took 16 secs, (640K rows) now less than 1 second