SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    Non-Member XX7509's Avatar
    Join Date
    Feb 2003
    Location
    Antarctica
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is there a better database then Access?

    Is there s better datbase then Access? I don't want to use MSSQL or MySQL because I'm building a windows application not a web application, and playing with all the MSSQL licensing on personal computers would be too much. Basically I am building business management software, like QuickBooks, for example. So anyone that has used QuickBooks, can imagen all the data I'll need to keep track of. Does anyone know what type of database (or whatever) QuickBooks uses? I think Access will work just fine, because it's basically a 0-5 user application, but the databases are HUGH! like I have a QuickBooks file with about three years of data in it thats a LOT of data, and it's about 134k. I build one database in Access and with just a few tables, and no data it's about 400kb, I start adding a few records and it gets to almost 4mb, I tried compacting the database etc... and it helps a little but not going to make a difference. I'm wondering how much data can be in a Access database, compaired to size, is each character stored in the database still 1k? I'm just trying to figure out how to get a good database for my software, but yet keep the files small enough so they are easy for the users to handle, and backup to floppys etc...

  2. #2
    midnight coder
    Join Date
    Dec 2000
    Location
    The flat edge of the world
    Posts
    838
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For backup to floppies etc, just zip the database file, I know Access db compresses very well, try it.

    I thinkFirebird could be an alternative, but I never tried it myself, it's the sucessor to Borland InterBase:

    http://firebird.sourceforge.net/
    Work smarter, not harder. -Scrooge McDuck

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    access is fine for what you propose -- i've used access on a database with several tables of 100k rows, and the database itself almost 1 gigabyte

    i think the upper limit is 2 gigs or 4
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by XX7509
    ...is each character stored in the database still 1k?...
    I hope you mean 1 char == 1 byte

  5. #5
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    From "Microsoft« Access 2000: Choosing between MSDE and Jet White Paper"
    Appendix B: Access/Jet (.mdb) Specifications

    File size (.mdb filetype) 2 GB
    No. of objects in a database 32,768
    Modules 1,000
    Number of characters in an object name 64
    Number of characters in a password 14
    Number of characters in a user name or group name 20
    Number of characters in a table name 64
    Number of characters in a field name 64
    Number of fields in a table 255
    Number of open tables 2048.
    Table size 1 gigabyte
    Number of characters in a Text field 255
    No. of characters in a Memo field (data entered via UI) 65,535
    No.of char. in a Memo field (data entered programmatically) 1 gigabyte
    Size of an OLE Object field 1 gigabyte
    Number of indexes in a table 32
    Number of fields in an index 10
    Number of characters in a validation message 255
    Number of characters in a validation rule 2,048
    Number of characters in a table or field description 255
    Number of characters in a record 2,000
    Number of characters in a field property setting 255

  6. #6
    Non-Member XX7509's Avatar
    Join Date
    Feb 2003
    Location
    Antarctica
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, I ment 1byte, I wrote that post in the middle of the night.

    On the reply about compressing the database, how can I do that? Does access have some build in compression that I don't know about? I could use zip or somthing, but then the user would need to have zip installed? Is there a windows compression api or some examples on how to compress a file with it? when the user clickes "Create Backup" the software will need to compress the file and copy it to the new location, I have no idea how to compress the file with code, I've never had the need to do that yet.

    Off Topic:


    Another question might be, how can I use .Net to store some settings in the Registry? In vb I used GetSettings, and SaveSettings It looks like they may have been removed from .net... or I forgot the correct formatting for them

  7. #7
    midnight coder
    Join Date
    Dec 2000
    Location
    The flat edge of the world
    Posts
    838
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Maybe your business management software can use something like the zlib library, so user can say select "Create Backup", and your software will give them a compressed Access db.

    http://www.gzip.org/zlib/

    There're probably other libraries out there, that's just one that I know about, never used it
    Work smarter, not harder. -Scrooge McDuck

  8. #8
    Non-Member XX7509's Avatar
    Join Date
    Feb 2003
    Location
    Antarctica
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmm... I never thought about 3rd party. I did a search on what you suggested, I downloaded the Zlib, but noticed it was only in beta version. I searched for more and found quite a few:
    http://www.google.com/search?hl=en&l...ibrary&spell=1

    I didn't look at all of the results. But I did locate this one designed for .Net Framework, and its version 2.0.

    http://www.xceedsoft.com/Download/ZipNet/index.htm

    It says "Add Feature-Ritch Compression to your VB.Net or C# software applications."

    I think it's going to be the best one I could find. But I'm new at the compression stuff, does anyone else have any opinions on any of these?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •