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