optimization via selection sets/indices

Walter Vaughan wvaughan at steelerubber.com
Tue Oct 12 17:11:23 PDT 2004


Robert Haussmann wrote:
<slow report using fpodbc with "or" in select statement>

Glad you got it to work. Something else for other fpODBC users to try is 
to remote desktop to the server that is running the report rather than 
moving all that data over the network.

Yesterday I started this email when I was in a Evansville IN hotel with 
wired high speed internet. I take a Linksys 11 mhz wireless router with 
me so I don't have to deal with cords all over the place. I came up with 
a quite interesting result with using Putty direct from the laptop or 
using my laptop to Remote Desktop into my PC on my desk back in NC.

Using Mark L's example...
time perl -e 'for ($x=0;${x}<5000;$x++){print ( getppid(), "\n" ) ; }'

Dual Xeon FreeBSD to WinXP client running SSH feeding last 20 feet via 
wireless @ 11 Mhz
0.010u 0.025s 0:18.49 0.1%      18+492k 0+0io 0pf+0w

Same command run to same server through same client app except running 
via my remote desktop in NC (still viewed over wireless)
0.000u 0.078s 0:00.14 50.0%     8+224k 0+0io 0pf+0w

20 seconds vs. instantaneous. Ah, the wonders of loosely coupled display.

More OT wireless XP stuff...
The tools for dealing with access points in XP-SP2 is almost perfection.
Night and day. No, more like CP/M vs. FreeBSD.

--
Walter
back in NC tonight


More information about the Filepro-list mailing list