NOTE: This page has been translated automatically from Russian to English. Original page.
Plug-in for the treatment of unloading and loading of large databases in 1C 7.7
Description of the problem
TasStas writes: During the discharge was observed that 1sv7 25 release, creates a temporary file in the database directory called 1Cv77.dat. The size of the file grows in the process of unloading and before it reaches the end of the 9.2 giga. After that, we get in the specified directory zipovanny file size of 164 meters. The files containing 1Cv7.md, Users.usr, 1Cv77.dat. But 1Cv77.dat file size in this case is 1.4 giga. When you try to boot get a message such as "Database Error". I think that this is a problem built into the 1C zip'a - does not want to work with files larger than 2 gigabytes. But how to change the built zipovschik not know. Who can met with such problems it please help. Thanks in advance.
Actions during unloading
When data upload completion plugin will display a message (in the system tray) that in a ZIP archive will get an empty file DAT, and 1Cv7.dat file itself will be in the directory under the name IS romix.dat.
Actions when loading
When loading the data (at the beginning) will issue a plugin file query box "Specify the file from which to take the unloading 1Cv77.dat".
Select the file (the default is romix.dat in the directory information base), and click the "Open" dialog box. Will begin downloading data.
Upon cancellation of the file selection, loading data from a file with the extension ZIP go gracefully (ie, take DAT ZIP archive).
The program displays messages on the percentage of load in the tray.
After the transactions upload and download, I recommend to disable the plugin ini file (in plugins folder, see. Installation description), and then it will not be loaded in 1C.
The test database
Check on a test basis, whether successfully pass upload and download your database.
The development kit also includes the unloading of large BigBase.rar base (it includes software generated data), which I used to test development. I enjoyed the 25 release of 1C: Enterprise 7.7, for more new releases - 26 and 27 - it seems there is no difference.
installation Procedure
plugin installation description - in the readme.txt file in the Patch folder complete the installation.
Possible problems
To avoid problems with loading do the following things:
1) Create an empty (blank) the SQL database (otherwise at the end of the download can write something about the uniqueness of keys and fall off).
2) Create a constant and save the configuration (otherwise writes at the beginning of the download error). This is not my problem, but the initial 1C.
History
24.02.2007 added interception SetFilePointer, because this system call spoiled the picture at startup (it was impossible to download data more than 2 GB).
21.03.2007 change messages when unloading and loading (I hope that in a clear way). When loading added DAT file selection dialog (once again not to copy and not move it if the unloading and loading occurs within a single computer).
01.07.2007 Rewritten function? GetSinceCheckpoint @ CDB7Stream @@ QBEJXZ,? Checkpoint @ CDB7Stream @@ QAEXXZ 'and? NextChar @ CDB7Stream @@ UAEXXZ, because they contained a 4-gigabyte limit.
The display of percent load, and sleep every 1ms 64K read data.
27.02.2008 cleaned issue when uploading data to enable the discharge packet scheduler.
28.10.2011: avgreen sent a version for Windows 7 http://infostart.ru/public/96481/