Subject | Improve query performance |
---|---|
Author | yolisqlmax |
Post date | 2004-04-07T07:59:08Z |
Hello!
I have to make some queries of a firebird database, but not from
firebird, from MSSQL.
I've tried to make this with two oledb providers: ibprovider and
zstyle oledb provider. With the ibprovider it takes more than 5
minutes to obtain 570000 records, and the zstyle provider doesn't
return me that amount of data.
Time is my enemy, I need to find a good solution ASAP!
Can anybody help me???
Thanks in adavance!
Yoli
I have to make some queries of a firebird database, but not from
firebird, from MSSQL.
I've tried to make this with two oledb providers: ibprovider and
zstyle oledb provider. With the ibprovider it takes more than 5
minutes to obtain 570000 records, and the zstyle provider doesn't
return me that amount of data.
Time is my enemy, I need to find a good solution ASAP!
Can anybody help me???
Thanks in adavance!
Yoli