Main Area and Open Discussion > General Software Discussion

Snap DB shared on a network?

(1/1)

garyreif:
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:
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? -garyreif (July 12, 2012, 10:55 AM)
--- End quote ---

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

Navigation

[0] Message Index