![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 14 of 14 total |
![]() |
Tue, Jan 11 2011 2:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< I've just been doing a bit of investigation and it seems that the OnGetCellColor event is fired 3 times for each cell when setting the grid up. >> Are you sure that it isn't fired during any repaint ? << But that still doesn't answer the question as to why a locate is so much slower than a prepared parameterised query when they are both executed the same number of times. >> I thought that the situation was the opposite ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jan 12 2011 4:52 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
><< I've just been doing a bit of investigation and it seems that the >OnGetCellColor event is fired 3 times for each cell when setting the grid >up. >> > >Are you sure that it isn't fired during any repaint ? Pretty positive, but with code never absolutely certain. I tried Update and Refresh and the OnGetCellColor event didn't fire. ><< But that still doesn't answer the question as to why a locate is so much >slower than a prepared parameterised query when they are both executed the >same number of times. >> > >I thought that the situation was the opposite ? Woops, for slower read faster ![]() Roy Lambert |
Wed, Jan 12 2011 3:03 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< Pretty positive, but with code never absolutely certain. I tried Update and Refresh and the OnGetCellColor event didn't fire. >> I'll have to double-check, but those may not trigger a repaint unless part of the control's canvas has been invalidated/changed. << Woops, for slower read faster ![]() If you want to send me the database and the relevant Locate/query info, I can tell you for sure what's going on. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jan 13 2011 5:28 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
>If you want to send me the database and the relevant Locate/query info, I >can tell you for sure what's going on. Unless you particularly want to delve into it its not worth wasting your time on. I have a solution which works and that's good enough for this bit of the app. Roy Lambert |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |