>Hi all… I’m fairly new to the Visual side of things, but I consider myself pretty dangerous with the good ole 2.6 stuff. Anyway, I’ve been tasked to take some of our 2.6 in house utilities and convert them to Visual FoxPro 7.0 and I’ve run into some performance issues on the Windows 98 workstations.
>
>Situation:
>Database located on a Window NT Server (RAID 5 SCSI HardDrives).
>Multi-user Fox 7.0 Exe resides on the Windows 98 Workstation - PII 400 – 128 mb Ram.
>Multi-user Fox 7.0 Exe resides on a Windows 2000 – PII 400 – 128 MB RAM.
>Using Optimistic Table Buffering in coordination with a lot of Transact SQL SELECT statements (i.e. a lot of TableUpdates).
>
>Problem:
>Processing 1000 Data Items on the 2000 Machine takes about 5 minutes.
>Processing the Same 1000 Data Items on a 98 Workstation takes HOURS.
>
>…They’re doing a lot of SELECT * From TableA into ARRAYs. Manipulating the Arrays, then Outputting text files. This is definitely not the way I would have attacked the problem, but it works. What concerns me is the disparity between the 2000 machine and the 98 machine. Any thoughts or ideas where I can even start.
Is there an aggressive real-time virus scanner running on the W98 machine?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up