just need to vent, so this is to nobody specific.....
<rant>
yeah - people think they can code, and come up with some unmaintainable spaghetti logic using their siblings names as variables....
this is why the ibm model almost works - write function point specs. then some mba type can decide on physical architecture, and
it takes 4k of data to write 'hello world' to a screen......don't forget the three people tracking progress - you said it was going to be done today,
why isn't it done? they make more than everyone with a tech degree.
so at this point in time, so much is already written, and the programmers job is to look crap up on the internet and choose the right library..holy crap it is in a different language,
so load the run time environment for that baby, and call it through its rpc interface (do they call it that anymore, or do i need to use corba, or web services, or ajax.......)
had a person show me how they used some color bleed thing off a menu, and claimed i can't do that on a computer. yeah, writing a color bleed was a sophomore project in comp graphics...
no way i can get it to work from a menu....'do you know excel?' if i hear that one again.....
large volume data management is about logistics - fault management/recovery. physical modeling, consistency/bounds/integrity. doesn't matter if it is on the load or query side....
there are more, poorly chosen data types out there - well, the values are numeric 1-11, so it is an integer......boom! it is now 8x larger than a optimized data type, and could be encoded into half of that....forget using real algorithms - oh, the database will shrink it using run-length encoding....nah.
check this -
isqrt = (int)(floor(sqrt((double)ihypotenuse))); /** call this thing about 500 million times, and see how long it takes
as opposed to about 8 lines of code that works with the integer directly....
a better idea is to create a cache table, cause i bet the input range is bounded....for things like getting gmtime or localtime this works great.
had some old school operations management phd hand me a 10 page document on how to update his database using the pull down menus in toad and arcmap.....
very proud of his instructions, i automated it into "run this" cause he didn't trust the system to run it...
and this is why i hate computers now. i like clients tho, cause they have some cash so i can get a fat bike.
</rant>