Hi,

At December 31, 2004, 00:15, Hardy wrote:

> I still cannot find which part on my writing Blob application that slows
> down ?? Database file size around 13MB

> Hello friends can you give me any suggestions or help ?

> ** I have increased the database page size from 1024 to 4096 and 8192
> and re-tested the database writing speed. Result I got only 2 seconds
> improvement. Initial speed was 30 second on 1024 page size

> ** On the application side I used "Client Dataset components" on the
> client, and "Query components" on the server. I do not use "Table type"
> at all. Also do not use BDE at all, we used Interbase Express 4.52
> Components instead.

So, I'm guessing that you are using MIDAS(or Datasnap) for your
n-tier layer! If you take that out of the equation and try a test
application only using IBX, what is your retrieval speed? Is it still
30 seconds?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)