Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Background verify
Mon, Jan 11 2010 5:34 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

I don't know if its technically possible or not but I'd love something I could run as a separate thread, or exe to check the database out. Due to cold weather (office temp sub 11C this morning) I had to kickstart my server PC. Since the email part of the app has been running and I have no idea if anything nasty has happened I always run a repair in these circumstances.

Most tables take approximately zero seconds but the biggies (like email) take up to 30 mins. All of this is dead time.

Something to run in the background in a non-exclusive fashion which ended up saying either everything looks fine or for gods sake repair would be a wonderful thing.

Roy Lambert
Mon, Jan 11 2010 11:49 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Something to run in the background in a non-exclusive fashion which ended
up saying either everything looks fine or for gods sake repair would be a
wonderful thing. >>

The problem is that a verification would need to, at the very least, hold a
read lock on any table that it is verifying.  Are you wanting to write to
any of these tables, or just be able to open them ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jan 11 2010 12:53 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

><< Something to run in the background in a non-exclusive fashion which ended
>up saying either everything looks fine or for gods sake repair would be a
>wonderful thing. >>
>
>The problem is that a verification would need to, at the very least, hold a
>read lock on any table that it is verifying. Are you wanting to write to
>any of these tables, or just be able to open them ?

What do you think Smiley However, if there's a half way house where I could use them but couldn't update that would be a lot better than nothing.

Fortunately its no longer as often as with the infamous BDE "blob has been modified" or as much of a problem as when I have 10 consultants all twiddling their thumbs. When its just me I can usually find myself something to keep me busy, but other users won't be in the same position and will probably elect to just keep using it. 99.99% of the time that's going to be fine its just that whenever I have to do something horrible to the machine I like to be sure.

Roy Lambert
Mon, Jan 11 2010 1:45 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< What do you think Smiley However, if there's a half way house where I could
use them but couldn't update that would be a lot better than nothing. >>

There are two aspects of the repair/verify that I'll be working on for an
upcoming minor release:

1) Faster index creation and rebuilds
2) Verify that runs in-place on a table, and can be run at different
"levels" so as to allow the developer to "drill down" and get more detailed
about how the table is examined

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jan 12 2010 1:42 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>1) Faster index creation and rebuilds

Always welcome

>2) Verify that runs in-place on a table, and can be run at different
>"levels" so as to allow the developer to "drill down" and get more detailed
>about how the table is examined

I read that to say there'll be a "quick&dirty" and a real detailed scan.

Roy Lambert
Wed, Jan 13 2010 8:56 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I read that to say there'll be a "quick&dirty" and a real detailed scan.
>>

Yep.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image