im getting ready to write a new app. before I start though I am wanting to decide what database to use for it.
I know with access my app can run on a windows system without any added installs where Sql server express needs to be installed.Code:my requirments are: 1. must be a stand alone(such as Access) possibly sql server express??? 2. I need the ability to do large databases. (access = 2GB, SQL S. E=4GB) 3. Speed
All of the records will be exactly the same size
the data will be "random" bytes.(0-255)
I thought creating binary files to store this data but I am not sure on:
If any one can share their expreriance I would really appreciate itCode:a) any size limits when dealing with VB6 b) single read size limit(such as can read ???K from file at a time) c) appending speed(once the data is written to the database/file it wont be changed. new entrys will be added but never changed.
Thanks




Reply With Quote