Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Slow |
Sun, Oct 31 2021 9:16 AM | Permanent Link |
Kees Lagendijk | Hi!
Why is this query so slow? select sum(bedrag) as saldo from adm_journaal where periode<202101 and rekeningnummer=12002 Tx, Kees Attachments: adm_journaal.rar |
Mon, Nov 1 2021 3:48 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Kees
1. Please do not post 42Mb to a normal newsgroup - post the attachment to the binaries 2. running it here I get >>>>> 1 rows affected in 0.016 seconds That's not slow in my view so there must be other things affecting it. Questions: 1. Have you tried running it in DBSys and checking the execution plan? 2. Is this being run natively or over a LAN, or a WAN I'm sure there are others but none occur right now. Roy Lambert |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |