Simon

One time, I test ODBC with PC performance on IMAGE. It was sluggish,
I change default blockMax to Maximum(2560), It boost speed few times...
All my ODBC/32 Database Schema is now "$control BlockMax = 2560".

Not exact science, but visible difference on speed.

Cheers

Peter Chong
Sr. ERP/MRP Analyst.
714.956.9200 x 363

>>> "Simonsen, Larry" <[log in to unmask]> 12/10/99 08:01AM >>>
Trying to understand the blockmax setting in TurboImage/XL a little better.
From what I have gleaned from reading I find this.

MPE/ix reads in chunks of 4096 bytes called pages or 16 sectors.
Turbo image stores in blocks as large as blockmax but may be smaller but
always a multiple of  256 bytes.

What happens when multiple TurboImage blocks will fit in a 4096 page?
What happens when a block spans a page, i.e. block size of 640 bytes.  The
first 3 blocks fit into the first page and then the next block has part in
one page and part in the next page?
Should blocks be made to be an integer fraction of a whole block?
Can blockmax be made 4096?
What should I be optimizing?

-------------------------------------------------
Larry Simonsen                Phone: 801-489-2450
Flowserve Corporation     Fax: 801-491-1750
PO Box 2200                    http://www.Flowserve.com 
Springville, UT 84663      e-mail: [log in to unmask] 
-------------------------------------------------
All opinions expressed herein are my own and reflect, in no way, those of my
employer.