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
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.
