Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread How i can optimize the read of Read Only database ?
Fri, Jul 31 2009 9:00 AMPermanent Link

"Mauro Botta"
Hi

I have an application with big database, these databases are installed on
disk C:

i read read... read read...read read...read read...  only.

Much DevExpress grid, big filter.  notthing write operation.

There db are usage in multi users enviroment, shared on network.  ( no c/s )

How i can optimize the access, the read, of there .dat files ?
( optimistic lock ? Set readonly property od TDbIsamtable ? )

Fri, Jul 31 2009 9:29 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mauro

Try increasing the buffers


MaxTableDataBufferSize
MaxTableDataBufferCount
MaxTableIndexBufferSize
MaxTableIndexBufferCount
MaxTableBlobBufferSize
MaxTableBlobBufferCount

and BlockReadSize

check out the manual, and you'll need to experiment

Roy Lambert [Team Elevate]
Image