Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread How to set LargeFileSupport for DBIsam Server
Sun, Dec 10 2006 8:23 AMPermanent Link

Max Terentiev
Hello,

How can i set LargeFileSupport=true for DBIsam Server ? I can't find this option in
server's INI file.

I found this note in manual: "do not mix applications or DBISAM database servers that have
large file support enabled with applications or DBISAM database servers that do not have
large file support enabled."

I can set LargeFileSupport in my application (on client side) via
TDBIsamEngie->LargeFileSupport property.
But how can i enalbe large file support in DBIsam Server ? It's nescessary to re-compile
DBIsam Server application ?

And second question: can LargeFileSupport slow-down my application (executing queries, etc) ?

Thanx for help !
Sun, Dec 10 2006 10:16 PMPermanent Link

Jason Lee
Hi Max,

LargeFileSupport is a property of the TDBISAMEngine component. This
property needs to be set prior to the engine becoming active; therefore,
you will need to recompile the project with the property set, or
recompile and provide a mechanism to set the property before the engine
becomes active (e.g. reading from an .ini file to set the property).

Regards,

Jason Lee

Max Terentiev wrote:
> Hello,
>
> How can i set LargeFileSupport=true for DBIsam Server ? I can't find this option in
> server's INI file.
>
> I found this note in manual: "do not mix applications or DBISAM database servers that have
> large file support enabled with applications or DBISAM database servers that do not have
> large file support enabled."
>
> I can set LargeFileSupport in my application (on client side) via
> TDBIsamEngie->LargeFileSupport property.
> But how can i enalbe large file support in DBIsam Server ? It's nescessary to re-compile
> DBIsam Server application ?
>
> And second question: can LargeFileSupport slow-down my application (executing queries, etc) ?
>
> Thanx for help !
>
Mon, Dec 11 2006 2:13 AMPermanent Link

Max Terentiev
Hi Jason,

But TDBISAMEngine contains EngineType property. In my application its'
should be etClient. But how i can set LargeFileSupport for EngineType=etServer ?
Or it's not needed ?

Thanx.


Hi Max,

LargeFileSupport is a property of the TDBISAMEngine component. This
property needs to be set prior to the engine becoming active; therefore,
you will need to recompile the project with the property set, or
recompile and provide a mechanism to set the property before the engine
becomes active (e.g. reading from an .ini file to set the property).

Regards,

Jason Lee
Mon, Dec 11 2006 1:01 PMPermanent Link

Jason Lee
Hi Max,

If you use DBISAM client/server, then you have to recompile the dbsrvr
project with the LargeFileSupport property set. In this case, your
application's LargeFileSupport property is irrelevant.

Regards,

Jason Lee


Max Terentiev wrote:
> Hi Jason,
>
> But TDBISAMEngine contains EngineType property. In my application its'
> should be etClient. But how i can set LargeFileSupport for EngineType=etServer ?
> Or it's not needed ?
>
> Thanx.
Mon, Dec 11 2006 2:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Max,

<< I found this note in manual: "do not mix applications or DBISAM database
servers that have large file support enabled with applications or DBISAM
database servers that do not have large file support enabled."

I can set LargeFileSupport in my application (on client side) via
TDBIsamEngie->LargeFileSupport property.  But how can i enalbe large file
support in DBIsam Server ? It's nescessary to re-compile DBIsam Server
application ? >>

That passage in the manual should be a little clearer.  What we mean by
"mixing" is that you shouldn't have multiple processes with different
LargeFileSupport settings *directly* accessing the tables.  Remote
applications using remote sessions don't apply in this case because they
aren't directly accessing the tables.  Therefore, in your case the only
change that needs to be made is in the dbsrvr.ini file or via the
command-line parameters:

For the .ini:

'Large File Support'=1

For the command-line parameters:

/lf

<< And second question: can LargeFileSupport slow-down my application
(executing queries, etc) ? >>

No, not at all.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image