Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 12 of 12 total
Thread VERY slow query/filter execution !
Tue, Dec 12 2006 11:20 AMPermanent Link

Max Terentiev
Tim, Robert !

Thank very much for your suggestions and your time !

Wed, Dec 13 2006 1:26 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PagePage 2 of 2
Jump to Page:  1 2
Image