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