1. Beatrix Willius
  2. Valentina Database ADK
  3. Tuesday, April 28 2020, 04:32 AM
  4.  Subscribe via email
My databases can become very large. Even for a medium sized database like 80 GB the diagnosis is taking very long.

After adding data my app does a diagnosis with a none as detail level:


dim VerboseLevel as Integer
if Fast then
VerboseLevel = EVVerboseLevel.kNone
else
VerboseLevel = EVVerboseLevel.kVeryHigh
end if


A user complained that my app would hang. I asked him to wait a bit longer. The diagnosis for his 80 GB database took half an hour. This was on the internal SSD and not even an external hard drive.

Half an hour is way too long. There is no progress to be had for the diagnosis. Was the diagnosis faster in earlier versions?
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Trixi,

We did not slow it I think and not touch. Not sure which early version you mean.

Your app starts to diagnose self, or the user needs to choose a menu command?

I think you already discuss with Ivan how to make progress-bar in Xojo.

Diagnose try to learn different dependencies inside of db and check if they correct.
I remember we did it even multi-CPU where possible.

Your db contains a lot of BLOB fields and records.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Beatrix Willius Accepted Answer
Yeah, I have too many blobs. I need to get those out of the database. A progress for the diagnosis would be very welcome.

My app does the diagnosis after adding data and the user can do the diagnosis himself.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
  • Page :
  • 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