I agree completely with most of the respondents here. My immediate impression too was that your application is a good candidate for using TClientDataSet to work with the data in-memory and to easily, if necessary, store updated data when the application is finished.
An excellent set of articles on TClientDataSet by Cary Jensen is at the CodeGear site. Part 1: http://dn.codegear.com/article/28876 Part 2: http://dn.codegear.com/article/28959 Part 3: http://dn.codegear.com/article/29001 Part 4: http://dn.codegear.com/article/29056 Part 5: http://dn.codegear.com/article/29122 Part 6: http://dn.codegear.com/article/29176 Part 7: http://dn.codegear.com/article/29271 Part 8: http://dn.codegear.com/article/29272 Part 9: http://dn.codegear.com/article/29297 Part 10: http://dn.codegear.com/article/29416 --- In [email protected], "Fred" <[EMAIL PROTECTED]> wrote: > > Hi All, > > Questions: > 1. What is the best database to use in the following application? > 2. Could I put the database in RAM memory so the hard drive won't > be busy? > > Application: > I build free submarine simulator software for teachers to teach > math and science to children. They perform scientific and > humanitarian missions only! > The database is dBase (.dbf) with 40 records (20k bytes) which hold > the location, speed, depth, course, ... for each contact (ships, > submarines, whales, navigarional aids, ...) The master math engine > (on CPU 1) updates data once every second, and other CPU's (Radar, > Sonar, Ships, Submarines, Aircraft, ...) read the data once every 2 > to 8 seconds. I can hear CPU 1 hard drive being very busy. I use > Delphi 5 and 2006. I suspect there is a better database for my > application than dBase! > Any thoughts! >
