i'm trying to get a 'best practices' feeling for how to do database style tables with rms. say i want 2 tables: users and companies. rms doesn't support traditional database tables, so how to go about storing the data in a table like structure? as far as i can see, i've got two options:
a. create 2 recordStores. each recordStore is a table that will hold user and company info.
b. put everything into 1 recordStore and delimit the tables with a special character, such as ^.
my gut feeling is that creating separate recordStores for each table i need will make the project easier to understand and help keep the code clean, but am i going to get a performance hit from opening/maintaining so many recordStores? in the scenario above, i've only got 2 tables which means 2 recordStores, but this could easily grow to 20+ tables with a more complicated project.
anybody care to share their recommendations?
tks