search

themaniac27 / Budcord

Blank Repo that has no purpose. I just want issue tracking.
0 stars 0 forks source link

Remove vector queries, add create tables for list #38

Closed themaniac27 closed 11 years ago

themaniac27 commented 11 years ago

To improve performance each patient will have their own tables for lists. When a patient is created, tables for medication, belongings, their individual charts need to be created.

Why? - If we cram all users to one table a large database will take a long time to perform a search. If we dynamically call a table (ie 989893928MedicationList) we will only get that patient data. Yes it will create a crap load of tables but performance should improve since we will only search through one patient compared to 1000s.

How? - When a user creates a record, create all tables. When we want to call a record, dynamiacally pass the table name and get the records. We want to remove all vector queries, and just pull the records normally from the tables.

themaniac27 commented 11 years ago

Moved to Operation GUI Save from Operation Clean Code

themaniac27 commented 11 years ago

Also see issue #65

themaniac27 commented 11 years ago

We are using views instead of tables for individual records