First hadd in record of big file is slow (only on Windows XP not on a window 2000 or server2003)

Have made a program with WINDEV 11.
When I startup my computer with windows XP and run the program.
By adding a record in the file with +/- 3000000 records it waits for 40 seconds to add the record , (Startprofiler).

This problem is not happening on a windows 2000 or a server 2003.

Have send a message to PCSoft but they don't know the problem?

Anybody knows the problem?

Hi...

It could just be the classic system restore problem: Windows consider that ndx files are part of the files to be saved for system restore points...

You can deactivate the system restore to veiry it's coming from there, and if it's the case, include in your software the registry changes needed to make ndx files not part of that functionality

best regards

Fabrice Harari
WinDev, WebDev, WinDev Mobile Video Courses

Hi Fabrice

Did you known the registry-path?




@Ivo
I have the same problem with the very very slow first hadd()
pcsoft know this problem since version 8.
In Online-Help Version 11 you can read the tip: deactivate the system-restore.


best regards

Hi...

if I'm not mistaken, this should do it:
In the key
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\BackupRestore\FilesNotToBackup
Add by example the name of your application, and the files to exclude from the restoration system. By example:
"MyProgram" = "C:\MyFiles\*.ndx /s"
/s if for managing also the subdirectories

Best regards

Fabrice

Quote
Udo
Hi Fabrice

Did you known the registry-path?




@Ivo
I have the same problem with the very very slow first hadd()
pcsoft know this problem since version 8.
In Online-Help Version 11 you can read the tip: deactivate the system-restore.


best regards

Hallo

Thanks Udo and Frabice

Indead this works.

Best regards

Ivo

Hi Fabrice
Thank you for the answer.

I want to include the registry-Entry in my Setup-Programm.
I look into my own computer and see various elements in the registry.

Do you know the difference between controlset001 , controlset002, controlset003... ?

Udo

Hello


I deactivate the system restore -> Fast

Activate back my system restore


HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\BackupRestore\FilesNotToBackup

Add the value REG_MULTI_SZ

Name
My program
value
c:\ec\egd\data\*.ndx /s

Now I try to change the registry but no effect

What do i wrong?

Thanks for your response

I'm afraid its the wrong key

This is what I found at MS:

Method 3: Use Registry Editor to Disable System Restore
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 (http://support.microsoft.com/kb/322756/) How to back up and restore the registry in Windows
1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT
3. Under Windows NT, create a new key:a. On the Edit menu, click New, and then click Key.
b. For the name of the new key, type SystemRestore.

4. Create a new DWORD value:a. On the Edit menu, click New, and then click DWORD Value.
b. Double-click the new key to open the Edit DWORD Value dialog box.
c. Under Value name, type DisableConfig, under Value data, type 1, and then click OK.


That should do the trick is you are authorized.

Regards,
FrankM

Hello

This works , thanks Frank

Is there a method that you can deactivate the system restore on a directory ?

With regards

Ivo

Hi again...

be careful! This last method will DISABLE system restore, and I'm not sure that your users will like it very much if they have a system crash and can't go back because YOU disabled it without telling them...

To disable it for a directory, the key I gave you is the solution (as, if you look in the registry under this key, you can see some of the entries doing an *.*)

best regards

Fabrice

Hello

I always understood that the "CurrentControlSet" was the one that would need altering and not the numbered control sets as they represent either the last good set (001) or a failed set (002 or 003 etc).

Regards
Al

Quote
Ivo
Hello


I deactivate the system restore -> Fast

Activate back my system restore


HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\BackupRestore\FilesNotToBackup

Add the value REG_MULTI_SZ

Name
My program
value
c:\ec\egd\data\*.ndx /s

Now I try to change the registry but no effect

What do i wrong?

Thanks for your response

Hi

Did you restart the System after change the registry?

Udo

Hello

Yes I did , But we think that the system restore has to run one time
so this deactivate comes active.

Maybee because we work with group policy ?

I shut down the system restore compleetly and it works.

Greetinges

Ivo