Hi,
I have begun a custom app for our company. The application involves five
databases. I am struggling with what might be a good mix between resource
efficiency and ease of coding when it comes to loading and saving records to
the database. Here is what I'm thinking about doing. I would appreciate any
feedback on whether I am going astray or perhaps pointers on a better way.
I thought I would have two functions for each database. One to populate a
structure with a record and one to save a structure to the record. I could
pack data into the record as tightly as possible to save space. When I want
to edit the record, call my custom function to parse the record and populate
a structure. Then, when I want to write the record back, call my custom
function to take the new data in the structure and write back out to the
record.
Is that a valid approach ? I am definitely interested in hearing what others
are doing.
TIA,
Eric
