Is it possible to use DBISAM in local mode with files above 4gb? I know it is possible to rebuild the Server to cope with large files, but it isn't clear whether applications accessing local data can do so.

Also, if you have been running an application with tables less than 4 gb and then you have to switch over to large-file-size support do you have to do anything clever with the table files?

Yes - it should be fine. Just enable the Engine.LargeFileSupport property and you should be all set.

I don't think you need to do anything special to switch to large file support - it actually controls how locking is done so issue would only be concurrent use by apps that use large files support and ones that do not.

For example the standard dbsys does not have large file support enabled - you can still use it as long nobody else is using the tables at the same time. If you do need to modify the tables with dbsys while they are open by your app then you should recompile it with large file support enabled. If you have exclusive access with dbsys then you can use the shipping dbsys.

Raul

Adam,

<< Is it possible to use DBISAM in local mode with files above 4gb? >>

Yes.

<< I know it is possible to rebuild the Server to cope with large files, but
it isn't clear whether applications accessing local data can do so. >>

You don't need to rebuild the server - it's a command-line/INI file setting:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=d&version=7&topic=Configuring_Starting_Server

(under "Database Servers Provided with DBISAM")

<< Also, if you have been running an application with tables less than 4 gb
and then you have to switch over to large-file-size support do you have to
do anything clever with the table files? >>

No, just make sure that all applications/servers that directly access the
tables are using large file support, or you're going to see
corruption/locking errors.

--
Tim Young
Elevate Software
www.elevatesoft.com