Interesting thought... I have my own TCL manager which is full screen editor/tcl manager and saves the commands to a file with the Logon*Account as the ID. That could be considered "caching" inquiry requests. The .L at tcl is caching inquiry requests, and you can save them to file (with a few keystrokes). So therefore, you should be able to answer yes thereby satiating PHB demands for a plethora of optionitis as a requirement for purchase.
p.s., I love my TCL manager as I can play with statements till I get them working and then paste into a proc, or visa versa take from proc, play with it till additions are made, and paste it back. And three years later when someone wants me to recreate that "one time only" request, I do a search for filename or dict name till I find the statement - hit return and bingo, three year old request resurrected from the dead! Caching *is* good! Allen www.tortillfc.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony W. Youngman Sent: Tuesday, October 25, 2005 13:25 To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 SQL cache In message <[EMAIL PROTECTED]>, Don Kibbey <[EMAIL PROTECTED]> writes >Be carefull how you explain that to the "unwashed masses". I can just >see the typical PHB exclaiming that UV/UD does not have this feature, >therefore it must be inferior! That's why I thought quite hard about how to word it. And why I described it as "catch 22" and talked about PHBs :-) Unfortunately, relational has won the marketing wars, but imho the whole thing is totally unsound, primarily because it is based on maths without a single drop of scientific proof anywhere. Possibly the best way to say it to a PHB (provided he actually listens) is that "UD is faster than SQL to start with. Query caching would only slow it down". The other analogy I thought of is "which would you prefer, an engine that gets 150bhp with a turbocharger, or one that gets 200bhp without?". Cheers, Wol -- Anthony W. Youngman <[EMAIL PROTECTED]> 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source Pick ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/