RE: RE: Re: Optimizing..

>> Whats the point in people sendin gin problems they have like the one >> below, when you get dickheads that answer peoples queries saying ......... >Er no. If people send in questions like "how do I optimise a query >like this (SELECT yadda-yadda...) given table structures like this >(CREATE TABLE foo...) and record volumes like this with indexes like .......... >And my observations stand. All the information on performance tuning >*I* know could easily be found in the docs for the platform. If you >are the kind of person that does better with structured training, the >courses are excellent. (I know, I give them all the time.) (WHAT A SURPRISE, NOW WE KNOW WHY YOU'RE SAYING WHY COURSES ARE SO GOOD......) In my opinion, EXPERIENCE counts more than anything, and the best way to learn? Share somebody elses experience. >Performance tuning recommendations in the docs are *very* basic, and >sometimes >at odds with experience. One specific example - the number of CPU virtual .............. >I saw a posting to this effect from someone at hp.com a while back, and >tried >it. He was correct. >Ray Garrison Thank you Ray, you have proved the point, we have all learned from your experience something that does not appear or in inaccurate in a manual. Jamie ....................................................................... Item Subject: WINMAIL.DAT Could not convert Microsoft Mail Message Data item to text. Will attempt to 'shar' item as file '000nrao' at end of msg. # This is a shell archive. Remove anything before this line, # then unpack it by saving it in a file and typing "sh file". # # Wrapped by openmail at cim0 on Wed Apr 8 09:32:22 1998 # # This archive contains: # 000nrao # echo Compiling unpacker for non-ascii files pwd=`pwd`; cd /tmp cat >unpack$$.c <<'EOF' #include <stdio.h> #define htoi(c) (c<='9' ? c-'0' : c-'A'+10) main() { register int c, c2; while ((c=getchar())!=EOF) { if (c=='\\n') continue; c2 = getchar(); putchar((htoi(c)<<4) + htoi(c2)); } } EOF cc -o unpack$$ unpack$$.c rm unpack$$.c cd $pwd echo x - 000nrao '[non-ascii]' /tmp/unpack$$ >000nrao <<'@EOF' 789F3E22CD19010690080004000000000001000100010790060008000000E404000000000000E8 0001088007001800000049504D2E4D6963726F736F6674204D61696C2E4E6F7465003108010D80 0400020000000200020001048001001900000052453A2052453A2052653A204F7074696D697A69 6E672E2E00790701058003000E000000CE070400080009001C00160003001F0101008000003D00 000004003D000C0021004A616D6965204E61736800004F50454E4D41494C3A4A616D6965204E61 7368202F4D49532C434F4F4B48414D000000000000000000830D01208003000E000000CE070400 0800090017001B0003001F01010980010021000000413534413932463842454345443131313843 3233303041303234383533383136001007010390060060010000120000000B0023000000000003 002600000000000B0029000000000003002E000000000003003600000000004000390080AFDC4A C862BD011E004200010000000B0000004A616D6965204E617368000040004800A074D84BC862BD 011E007000010000001900000052453A2052453A2052653A204F7074696D697A696E672E2E0000 000002017100010000001600000001BD62C84A99F8924AA6CEBE11D18C2300A02485381600001E 001A0C010000000B0000004A616D6965204E617368000002011D0C01000000210000004F50454E 4D41494C3A4A414D4945204E415348202F4D49532C434F4F4B48414D000000001E001E0C010000 00090000004F50454E4D41494C000000001E001F0C01000000180000004A616D6965204E617368 202F4D49532C434F4F4B48414D0040000730C0F6BA9AC762BD0140000830C0F6BA9AC762BD011E 003D00010000000500000052453A200000000003000D34FD3700007245 @EOF chmod 660 000nrao rm /tmp/unpack$$ exit 0