1. Beatrix Willius
  2. Valentina Database ADK
  3. Sonntag, Januar 03 2016, 03:25 PM
  4.  Abonnieren via E-Mail
How long is loading an SQL dump supposed to take?

- Original database 100 MB
- Dump 450 MB
- MacPro 2009, 16GB

Duration of dump loading was over 20 minutes. Seems very long to me. My computer isn't the fastest but 100 MB is a tiny database.

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hi, Beatrix

Is journaling enabled for this database?

I've got similar results with journaling enabled.
Without a journal a dump file was loaded few times faster.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Okay, will test this.

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Hi Sergey,

I'm not seeing any difference. How should I disable/enable journaling? This is what I tried:

newDatabase.IsJournaled = False
newDatabase.LoadDump(DumpFolderitem, theFolderitem, EVDumpType.kSQL, "UTF-16";)
newDatabase.IsJournaled = True

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals


PS: This forum is so bad. Code formatting makes the text illegible.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hi Beatrix,

Can we get dump of such database - structure or structure + records?
Maybe, there is some specific things, which I can't reproduce yet.

Thank you!
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
This forum is so strange. Duplicate post again. Editing one post also changes the second one.

The invitation to the Dropbox folder is in your Inbox.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
I can see a shared folder, but it is empty for me.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
I live in the German hinterlands. My DSL is very slow and the upload will take a while longer.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello, Beatrix

Thanks for the dump.
Reading BLOB values takes much of the time.

I've created an issue in mantis: http://valentina-db.com/bt/view.php?id=7432

Ruslan will see, what can be optimized here.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Very good!
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
FIXED in 6.2.8 build.

FIX was done changing FLEX generating code from C++ to C
this was bug in FLEX :-(
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories