Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 07, 2016, 10:34:16 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Snap DB shared on a network?  (Read 796 times)

garyreif

  • Participant
  • Joined in 2012
  • *
  • Posts: 4
    • View Profile
    • Donate to Member
Snap DB shared on a network?
« on: July 12, 2012, 10:55:14 AM »
I am thinking about using Snap Db for a serial/ part number database.  It will be used intermittently by 4 users, from a shared folder on a SBS 2008 server.
Questions:
1) Is there a limit of how many records can be stored?
2) Does it get along with being shared on a network? Any issues to look out for?
3) Will it work as multi-user (simultaneous) or only be one user at a time?
Any help or comments are appreciated!

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,666
    • View Profile
    • Donate to Member
Re: Snap DB shared on a network?
« Reply #1 on: July 12, 2012, 01:11:31 PM »
I am thinking about using Snap Db for a serial/ part number database.  It will be used intermittently by 4 users, from a shared folder on a SBS 2008 server.
Questions:
1) Is there a limit of how many records can be stored?
2) Does it get along with being shared on a network? Any issues to look out for?
3) Will it work as multi-user (simultaneous) or only be one user at a time?

Hi, garyreif, and welcome to the site.  As to your questions:

1) I've tested it with around 80,000 records but, as the number of records grows, it's slower to load the file.  The largest database that I, personally, use it with has a few thousand records.
2/3) Sure, a single user could store the files on a network share (I do that with mine).  That said, I wouldn't recommend using it simultaneously in a shared environment as Snap DB is not multi-user aware whatsoever.

Keep in mind that Snap DB is not an actual relational database.  Rather, it's a simple flat-file system designed for relatively light use.  If you plan on using it in a commercial setting, you may want to explore some more robust options out there.  However, if you can make Snap DB work for your environment, that's great.   :D