RE: data base access
- Posted by Matthew Lewis <matthewwalkerlewis at YAHOO.COM> Aug 03, 2001
- 432 views
--- Jonas Temple <jktemple at yhti.net> wrote: > George Walters wrote: > 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) This is the approach I've taken with EuSQL, where an empty string indicates to use the current db/table. (It's possible to do everything through straight SQL commands or using the API functions to manipulate a db). > Rob, hoping that you read this, I would like to again request a thought > on indexes withing database.e. What do you think? I'm in the process of getting indexes to work with EuSQL. I've picked it up again, and have squashed a few bugs, and improved some other things, like how it handles 'where' clauses. My approach to indexes is to have a 'system' table, 'INDEXDEF', in which each index is stored. Queries can then use the index to quickly do (large) joins on the data. I'm actually using Jiri's a-list code to handle the indexes, which are stored with the indexed value as the list-key, and the list-data being a sorted list of the record keys which correspond to the value. Each record in INDEXDEF is an index on a field. ===== Matt Lewis http://www14.brinkster.com/matthewlewis