Control of integrity of database always at 0%

[Giuseppe Chillem]

I have had a system crash while importing books.
I have started the integrity check of the SQL Database but after one hour it is stuck at 0%.

[DoctorOhh]

Originally Posted by Giuseppe Chillem

I have started the integrity check of the SQL Database but after one hour it is stuck at 0%.

I think it goes from 0% to complete. I don't know how long it takes, I only run it when I don't plan on using it. If it hasn't come back with an error it is most likely still running. If it completes successfully it just goes away without any indication it completed.

[theducks]

Originally Posted by Giuseppe Chillem

I have had a system crash while importing books.
I have started the integrity check of the SQL Database but after one hour it is stuck at 0%.

1 hour can be shor or it can be way too Long.

It depends some what on how many books were in the Library.

As dwanthny said. It goes from 0 to 100% for the first phase of the chec ( think this is the actual SQL DB rebuild),
Then there is another phase with a more normal progress indication (I think this is checking the DB against the Filed titles).

On my (P4-3.2GHz) system, the first phase takes almost 10 minutes (1200+ books) with nothing else going on AND my A/V tamed with respect to my Library folders.

[kovidgoyal]

the db integrity check first dumps the SQL as text and rebuilds the database. This step can take a long time for a large database, and there is no progress indication while it happens as it is essentially a two step process.