350 MHz WinNT runs query slower than 120 MHz Win95

Jan

Delphi Developer

Sat, 16 Mar 2002 03:00:00 GMT

350 MHz WinNT runs query slower than 120 MHz Win95

I have a program which often runs a query, which on a 120 MHz machine
returns immediately, and on a 350 MHz NT runs about 10-20 times slower. Same
query, same underlying data.

On the Win95 machine there is an installation of Office95, on the NT machine
an installation of Office2000, to which i added the DAO3.0 library using
OpDAOInst.

This query runs on an MSAcces 95 database, is prepared, has two parameters,
runs on a table with ~40.000 records, has several indexes. All fields which
are used in the WHERE clause of the query are indexed.

I have no clue to this phenomenon. Has anybody experienced similar things?

Any help is appreciated.

Jan

miab

Delphi Developer

Sat, 16 Mar 2002 03:00:00 GMT

Re:350 MHz WinNT runs query slower than 120 MHz Win95

Quote

> I have a program which often runs a query, which on a 120 MHz machine
> returns immediately, and on a 350 MHz NT runs about 10-20 times slower.
Same
> query, same underlying data.

> On the Win95 machine there is an installation of Office95, on the NT
machine
> an installation of Office2000, to which i added the DAO3.0 library using
> OpDAOInst.

> This query runs on an MSAcces 95 database, is prepared, has two
parameters,
> runs on a table with ~40.000 records, has several indexes. All fields
which
> are used in the WHERE clause of the query are indexed.

> I have no clue to this phenomenon. Has anybody experienced similar things?

> Any help is appreciated.

> Jan

Are you using the same version of BDE?

miab

Jan

Delphi Developer

Sat, 16 Mar 2002 03:00:00 GMT

Re:350 MHz WinNT runs query slower than 120 MHz Win95

Yes, same version of BDE.

miab heeft geschreven in bericht <7sptuc$rf...@forums.borland.com>...

Quote

>> I have a program which often runs a query, which on a 120 MHz machine
>> returns immediately, and on a 350 MHz NT runs about 10-20 times slower.
>Same
>> query, same underlying data.

>> On the Win95 machine there is an installation of Office95, on the NT
>machine
>> an installation of Office2000, to which i added the DAO3.0 library using
>> OpDAOInst.

>> This query runs on an MSAcces 95 database, is prepared, has two
>parameters,
>> runs on a table with ~40.000 records, has several indexes. All fields
>which
>> are used in the WHERE clause of the query are indexed.

>> I have no clue to this phenomenon. Has anybody experienced similar
things?

>> Any help is appreciated.

>> Jan

>Are you using the same version of BDE?

>miab

Other Threads

1. Installing delphi 3.0 on PII 350 Mhz

2. Error 200 at 800 Mhz with BP7

3. Runtime Error 200 auf PC mit 800 MHz

4. CRT and 500 Mhz.

5. BP7, Win98 and 300-400 Mhz cpu's

6. Runtime Error 200 on High Mhz NT Machines ??????

7. Errors on High Mhz Computers?

8. >200 MHZ, 200 error continued ...

9. The CRT Unit and my new 300 mhz Pentium II

10. S: TP6.0-FUNCTION CPU+MHZ