Opening time after startup of Windows

[Leo Van den Brande]

Hi Ruslan,

Recapitulating:
The problem is that opening time of the database after startup of  
Windows is very long.

Develop on Mac with RB 2008 2, and Valentina 3.5.2, and build for Mac  
and Windows.
Mac OS 10.4.10, 1.0 GHz, 1 GB RAM. Recently Mac OS 10.5.6, 2.5 Ghz  
Intel Core 2 Duo, 4 Gb RAM
Windows: XP, 1.7 GHz, 1.24 GB RAM

Previous analysis:
You stated: "...And now I see that although for VarChar I have provide  
LAZY read of header
it is not made for BLOB. So this will be my FIRST step to improve your
issue."

For my testing you have provided a Valentina Studio (v4) in which this  
is implemented. There was a reduction: from 40-45 sec. to 20-23 sec.

Next, you considered the need for defragmentation:

  "...I see yet that Defragment() is not ported from 1.x code.  Wow. :-(
So we must do this also of course.
MAY BE it also will improve things...

You told me you would prepare a version in which this is implemented.  
I was waiting for that.

Present situation:
Previously, the database resided on the harddisk. With a truly large  
DB this is not possible. So, I have changed my program such that it  
reads from a DVD and adjusted the installer accordingly.
For testing, I prepared a DB that comes close in size (1.7 Gb) to what  
it will grow to (2-3-GB).

Some recent results: note that on second opening without going out of  
Windows the time is always short (2-3 seconds).
DB 1.6 Gb on DVD:
 From within the whole program (59 Mb for exe): 98-99 sec.
 From a test program (same code for opening DB but a minimum of other  
functions (34 Mb for exe): 47-55 sec
In VStudio (v4): 20-23 sec.

So, VStudio is quite efficient. With my program, opening time seems DB- 
size-dependent. The result with the whole program will not be  
acceptable for most students.
The test program is a bit better, and during opening, it could be  
chained with the whole origram, causing a rapid opening the second  
time. However, even then I am afraid this would chase away most  
students.

Since the opening process is done from within Valentina, is it  
possible to catch and store the information that Windows stores in its  
cache? When this is done once at installation of the program, could  
that information then be reused when opening the program? Or Is this  
too wild an idea?

I'm sure you will have better ideas on how to deal with the problem.

Thanks and kind regards,

Leo

Leo Van den Brande
J. Buziaulaan 61, Utrecht
(+31) (0)30 2511767
leo_van_den_brande at wxs.nl




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090216/b7e9929a/attachment.html