ImportASCII - English OS takes 8 seconds; German OS takes 20 Minutes

[Ruslan Zasukhin]

On 11/17/04 2:53 AM, "syalamar at fiberlink.com" <syalamar at fiberlink.com>
wrote:

> // ON AN ENGLISH WINDOWS XP SP1 MACHINE - THE IMPORTASCII CALL TAKES LESS
> THAN 8 SECONDS - NO PROBLEMS AT ALL
> 
> 
> // ON A GERMAN WINDOWS XP SP1 MACHINE - THE SAME IMPORTASCII CALL TAKES
> ABOUT 20 MINUTES.

So 100% the same data, the same db and the same code?

Only OS different?!

Wow.


> // IF I MOVE THE IMPORTASCII CALL BEFORE THE DELETE SQLEXECUTE STATEMENTS,
> IT TAKES LESS THAN 8 SECONDS.

> // LOOKS LIKE SOMETHING IN THE DELETE SQLEXECUTE CALLS IS CAUSING SOME
> THING TO SLOW DOWN THE IMPORTASCII CALL.

> // I TRIED db->Flush() AFTER EACH CALL TO SQLEXECUTE - STILL THE SAME
> PROBLEM.
> 
> // ANY IDEA WHAT COULD BE HAPPENING.

Is the cache size the same on both computers?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------