Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 12 of 12 total |
VERY slow query/filter execution ! |
Tue, Dec 12 2006 11:20 AM | Permanent Link |
Max Terentiev | Tim, Robert !
Thank very much for your suggestions and your time ! |
Wed, Dec 13 2006 1:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Max,
<< Now query is optimized (in Plan log) and execute fasten - about 17-20 seconds. But it's still to slow for me ! >> Are you using any index compression at all on the indexes ? 17-20 seconds sounds like a bit much even for 5 million records. Also, is the table local or located on a network file server ? If it is on a network file sever, then I would recommend using the DBISAM database server instead. Querying very large tables over a network will be very time-consuming compared to local access or access via the DBISAM database server. -- 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 Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |