![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Fri, Apr 25 2008 9:33 PM | Permanent Link |
Rob Fletcher | Is file share mode safe to use with EDB? Are the issues with Windows not really locking
files (oplocks? etc.) solved? I remember this being a big problem with btree filer. There were some registry settings that seemed to help. Do these problems exist with EDB? What is the max recommended users with file share mode? Thanks, Rob |
Sat, Apr 26 2008 11:13 AM | Permanent Link |
Fernando Dias ![]() | Rob,
> Is file share mode safe to use with EDB? Yes, it's at least as safe as any other app using file sharing. > Are the issues with Windows not really locking > files (oplocks? etc.) solved? EDB uses OS locking, and as far as I know it works very well. Windows had many problems with locks (opportunistic locking not working correctly, network redirector bugs, etc..) but these were windows problems, not EDB or DBISAM problems. So, the answer to your question is in what windows version and service pack you are using, because EDB locking stuff had always worked correctly ![]() > What is the max recommended users with file share mode? That depends on many factors... If there are many users reading and only a few updating the database, if on the contrary almost all users insert records frequently, what type of updates they normally do, the size of the database, the type of network connection, etc.. Personally, I don't use FS when there are more than 3 users if all of them can update the database frequently. However, if only 1 or 2 users write to the DB and all the other only read it, I usually extend this limit to 5; for more than this I always use Clint/Server. Note, once again, this is only based on my own experience, and is valid only for my applications/users. I heard about some cases where FS is used with success with 20, 30, 50 or even more users... -- Fernando Dias [Team Elevate] |
Sat, Apr 26 2008 12:03 PM | Permanent Link |
"Harry de Boer" | To add to this: if you want to use FS mode and choose a middleware solution
(kbmmw / remobjects, etc.) to 'sit' between apps and db you can handle lots of users. We have an app were hundreds of users (editing) use a dbisam db. I believe that with EDB this will work the same. Regards, Harry "Fernando Dias [Team Elevate]" <fernandodias.removthis@easygate.com.pt> schreef in bericht news:3BC07D59-4D43-4481-ADA4-4491A1DA2469@news.elevatesoft.com... > Rob, > > > Is file share mode safe to use with EDB? > > Yes, it's at least as safe as any other app using file sharing. > > > Are the issues with Windows not really locking > > files (oplocks? etc.) solved? > > EDB uses OS locking, and as far as I know it works very well. > Windows had many problems with locks (opportunistic locking not working > correctly, network redirector bugs, etc..) but these were windows > problems, not EDB or DBISAM problems. > So, the answer to your question is in what windows version and service > pack you are using, because EDB locking stuff had always worked > correctly ![]() > > > What is the max recommended users with file share mode? > That depends on many factors... > If there are many users reading and only a few updating the database, if > on the contrary almost all users insert records frequently, what type of > updates they normally do, the size of the database, the type of network > connection, etc.. > Personally, I don't use FS when there are more than 3 users if all of > them can update the database frequently. However, if only 1 or 2 users > write to the DB and all the other only read it, I usually extend this > limit to 5; for more than this I always use Clint/Server. > Note, once again, this is only based on my own experience, and is valid > only for my applications/users. I heard about some cases where FS is > used with success with 20, 30, 50 or even more users... > > > -- > Fernando Dias > [Team Elevate] |
Sun, Apr 27 2008 11:35 PM | Permanent Link |
Rob Fletcher | Can you tell me which versions of Windows do not have the locking problems?
Rob "Fernando Dias [Team Elevate]" <fernandodias.removthis@easygate.com.pt> wrote: Rob, > Is file share mode safe to use with EDB? Yes, it's at least as safe as any other app using file sharing. > Are the issues with Windows not really locking > files (oplocks? etc.) solved? EDB uses OS locking, and as far as I know it works very well. Windows had many problems with locks (opportunistic locking not working correctly, network redirector bugs, etc..) but these were windows problems, not EDB or DBISAM problems. So, the answer to your question is in what windows version and service pack you are using, because EDB locking stuff had always worked correctly ![]() > What is the max recommended users with file share mode? That depends on many factors... If there are many users reading and only a few updating the database, if on the contrary almost all users insert records frequently, what type of updates they normally do, the size of the database, the type of network connection, etc.. Personally, I don't use FS when there are more than 3 users if all of them can update the database frequently. However, if only 1 or 2 users write to the DB and all the other only read it, I usually extend this limit to 5; for more than this I always use Clint/Server. Note, once again, this is only based on my own experience, and is valid only for my applications/users. I heard about some cases where FS is used with success with 20, 30, 50 or even more users... -- Fernando Dias [Team Elevate] |
Mon, Apr 28 2008 3:53 AM | Permanent Link |
QuickAndDirty | I think the procedure is to ask Administrator where problems oocur with virus-scanners,
lockings, etc. If they want to solve the problem like define scanning exclusions, stop windows oplocks, replace the file server of ano tuk or if you should install the SQL server and work on save TCP/IP. |
Mon, Apr 28 2008 8:30 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Rob,
<< Is file share mode safe to use with EDB? Are the issues with Windows not really locking files (oplocks? etc.) solved? I remember this being a big problem with btree filer. There were some registry settings that seemed to help. Do these problems exist with EDB? >> EDB works the same way as DBISAM in this respect, so everything that applies to DBISAM also applies to EDB. << What is the max recommended users with file share mode? >> We normally don't recommend using more than 10-15, but sometimes people really stretch that number if it's mostly reading and not a lot of writing. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Apr 28 2008 10:44 AM | Permanent Link |
Fernando Dias ![]() | Rob,
> Can you tell me which versions of Windows do not have the locking problems? No. I can only tell you about my own experience, and what I can say about this is that I had many problems with Win 95 and NT4 and occasional problems with Win 2K and Win98. At the moment, all my current costumers use Win Xp with at least SP1 and/or Win Server 2003 and I have no locking problems at all. Note, however that I only use FS when the number of users is really small, as I said. -- Fernando Dias [Team Elevate] |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |