Re: Using a Database
- Posted by irvm at ellijay.com
Oct 14, 2003
On Monday 13 October 2003 10:21 pm, you wrote:
>
> I need to write out a file that has a six byte key (an account number) and
> a 500 byte record. The first two fields in the record contain the last
> name and the first name of a person. I need to be able to recall the
> person's record either by the account number or the first and last name.
> There can be several people on a network adding new records and updating
> existing records. It might be possible that two people try to change the
> same record at the same time. The system I am currently using has
> recording locking to keep this from happening. I understand the EDS
> database has file locking which I assume would only allow one person to
> read and write while the other six or seven computer operators drank
> coffee.
>
> 1. Am I correct in assuming that this is the way the EDS database works?
Yes. Plus you're probably going to have to write your own indexing routines
to find by name. Unless the database is very small, you don't want to be
reading thru the whole thing for each search.
> 2. If so, is it going to be changed. When?
? My guess is, never. There are lots of more capable database engines out
there.
> 3. If not, how does it work?
>
> 4. Should I skip the EDS and use MySQL with a ODBC wrapper?
Probably, or if you want to just get the job done fast and right, use
something like Filemaker. You'd be done in the time it took to write
this e-mail, and it has the record locking / simultaneous access problems
solved.
> 5. I don't have the slightest idea what I just said in #4 above. I
> downloaded MySQL and made a database from the command line and that's my
> experiance with that.
I don't know if the mysql wrapper is complete (or completely debugged).
Irv
|
Not Categorized, Please Help
|
|
