Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 19 of 19 total
Thread Very Slow Querys, not an SQL problem
Mon, Nov 30 2009 9:09 AMPermanent Link

Peter Lee
Hi Roy

My apologies for posting the same reply twice, I didn't think anything had happened as it took so long.  Is there a prefered route for larger attachments?  

I am using:

Windows XP Build 2600 Service Pack 6
Delphi 2006 Update 2 (10.0.2288.42451)
DBIsam 4.25 B7

I am not up to date with DBIsam as I have moved over to Elevate DB but have yet to use it seriously, perhaps now is the time.  I am also going to go to Delphi 2010.

I am glad you got similar results.  When I looked again today I found that only reming out the .Blobsize got rid of the problem.

I have seen Tim and Raul's tests, hmmm curious.

Peter
Mon, Nov 30 2009 9:17 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


Same question as for Peter - OS/Delphi/DBISAM versions? I do get the same problem which, since you and Raul don't, suggests its a version of some sort problem.

Roy Lambert [Team Elevate]
Mon, Nov 30 2009 10:47 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Peter

>My apologies for posting the same reply twice, I didn't think anything had happened as it took so long.

Now think how it feels to the poor soul with a dial up connection Smiley

>Is there a prefered route for larger attachments?

elevatesoft.public.binaries
>
>I am using:
>
>Windows XP Build 2600 Service Pack 6
>Delphi 2006 Update 2 (10.0.2288.42451)
>DBIsam 4.25 B7
>
>I am not up to date with DBIsam as I have moved over to Elevate DB but have yet to use it seriously, perhaps now is the time. I am also going to go to Delphi 2010.

Go for it. You will be swearing and cursing for a while but things do get better. I know <vbg>

>I am glad you got similar results. When I looked again today I found that only reming out the .Blobsize got rid of the problem.
>
>I have seen Tim and Raul's tests, hmmm curious.

Raul used the latest version and I'd guess Tim did as well. Unless someone mentions a specific version that's his best bet. You could try downloading a trial for V4.29 and see if that is the problem. You and I on V4.25 see the problem Raul and Tim on V4.29 don't. Curious is not the right word, suggestive is.

Roy Lambert


Mon, Nov 30 2009 11:00 AMPermanent Link

"Raul"


>>Windows XP Build 2600 Service Pack 6
>>Delphi 2006 Update 2 (10.0.2288.42451)
>>DBIsam 4.25 B7


Peter : how did you get to SP6? I'm reasonably sure SP3 is the latest one
for XP and my tests were run with XP SP3.


>>I have seen Tim and Raul's tests, hmmm curious.
>
> Raul used the latest version and I'd guess Tim did as well. Unless someone
> mentions a specific version that's his best bet. You could try downloading
> a trial for V4.29 and see if that is the problem. You and I on V4.25 see
> the problem Raul and Tim on V4.29 don't. Curious is not the right word,
> suggestive is.

In terms of DBISAM there have been number of changes specifically for BLOB
handling between 4.25 and 4.29 - I thought most dealt with the deleted block
re-use and such matters but maybe Tim can comment on the performance changes
that you're seeing.

I'd also suggest trying 4.29 and see if that "resolves" the issues you're
seeing.

Raul


__________ Information from ESET NOD32 Antivirus, version of virus signature database 4649 (20091130) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


Mon, Nov 30 2009 11:25 AMPermanent Link

Peter Lee
Raul

Thanks to everyone for the comments.  

Yes, its a typo,  it should have been SP3 not 6.

I will try the demo of the most recent version, I should subscribe to get the latest updates.

Cheers

Peter
Tue, Dec 1 2009 9:27 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

<< I will try the demo of the most recent version, I should subscribe to get
the latest updates. >>

Just a quick note of warning:

There is a new design for the BLOB reading/writing that is not compatible
with 4.27 or earlier.  Therefore, it is extremely important that you do not
mix DBISAM 4.28 applications with DBISAM 4.27 or earlier applications.
Mixing the two versions can cause improper truncation of BLOB data, and that
includes using a 4.27 application on any data that has been updated by
DBISAM 4.28, even if it is not concurrently.  The issue is that 4.27 and
earlier versions recylcle BLOB blocks on a per-block basis, whereas 4.28 and
higher versions recycle BLOB blocks on a per-row basis.

So, if you use 4.29 for testing, please do so on a copy of the database
tables.  This is especially true if you still need to use these database
tables with existing 4.27 or earlier applications that are being used in
production.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Dec 1 2009 9:29 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Same question as for Peter - OS/Delphi/DBISAM versions? I do get the same
problem which, since you and Raul don't, suggests its a version of some sort
problem. >>

4.29 B2
Windows XP SP3

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Dec 1 2009 5:26 PMPermanent Link

Peter Lee
Hi Tim/Roy/Raul

I have now upgraded to 4.29B2 and it has fixed the problem .

Sorry for the long pauses between replies, late shift this week (no escape till  23:00) so
not much spare time.

Thanks for the help and comments.

Peter

My versions were:

Windows: XP SP3
Delphi: 2006, Update 2, 10.0.2288.42451
DBIsam: 4.25 B5
Wed, Dec 2 2009 10:17 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

<< I have now upgraded to 4.29B2 and it has fixed the problem . >>

Fantastic.  I'm glad that the problem is resolved.

Thanks for the update,

--
Tim Young
Elevate Software
www.elevatesoft.com

« Previous PagePage 2 of 2
Jump to Page:  1 2
Image