> 1) If I use "Project -> Add -> Database -> New REAL SQL database" to add a > database to the project, is the entire database going to be loaded into RAM > as the program starts? > no. only an object - an empty container. to load the database into ram requires you to actively open it, get a record set and do something with that data.
> > 2) Do I have a way to decide whether the database is all in memory or > accessed > from the hard drive? > > Its on the hard drive. Unless you manually load it into arrays. > 3) Is the time to do a SELECT statement proportional to the size of the > database? i.e. If a particular SELECT statement takes, say, 1 second with > 20,000 rows, will it take 10 seconds with 200,000 rows? or is it > proportional > to the size of the database in MB? > A select might be ok, but sorts are never linear. if there are n records it can take n*n or n^(3/2) or n*ln(n). So it could go from 10 seconds to 100 seconds, in theory. _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
