Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 11 to 19 of 19 total |
Very Slow Querys, not an SQL problem |
Mon, Nov 30 2009 9:09 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 >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 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |