Hi Craig,
Thanks! You might want to download article Q191172 from MS. It relates to that problem and suggest that we use HAVING instead of WHERE in our SQL statements.
The article doesn't necessarily relate to my problem. My test SQL was "Select Distinct from Xtable". No where clause. The test ran significantly FASTER on a 233mhz Win 98 wkst with 64m of ram (VFP 5.0) than on a 4.5mhz II NT 4.0 WkSt with a 128m of ram using VFP 6.0. Also as I stated originally it ran even faster on a 233mhz NT 4.0 Server with 128m using VFP 6.0 than it did on the Win 98. But that is understandable -more ram and a SCSI drive. If I chase it down, I'll get back to you.
Regards,
Paige
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only