OpenEuphoria

RE: data base access

• Posted by Jonas Temple <jktemple at yhti.net> Aug 03, 2001
• 415 views

George Walters wrote:
> Thanks Jonas, you're right that eventually the multi-user issue has to 
> be
> solved. I have looked at your eds/net, and you do have some more direct
> access to records but the 'current table' issue would still be a problem 
> in
> a program reading from so many different data bases.
> 
> ..george
George,

Although I think your concern is valid I can't really say that having to 
do db_select and db_select_table would be a measurable problem from a 
performance/coding perspective.

Consider this...if Rob changed database.e to support multiple open 
databases as you suggested then you would have to code to support the 
different file handles.  Coding for the current method only requires you 
to supply a database name/table, something you would have to do anyway 
(since db_open requires a table name).

One thought would be to pass the database/table to each record access 
function in database.e.  For example:

record_data = db_record("mydb", "mytable", record_number)

Then database.e could handle the database/table switching internally.  
Maybe this is what you had in mind?

Rob, hoping that you read this, I would like to again request a thought 
on indexes withing database.e.   What do you think?

Jonas