Hi There, Am 23.09.2009 um 14:37 schrieb Joshua Hutchinson:
Keith,
While I agree that Marcello's diplomacy is terrible (always has been, doubt that's going to change! :) ... he's right and you're wrong.
He never claimed the DB has to reindex and he presented very real reasons why your solution is terrible from an efficiency point of view.
Biggest problem (summary): Your solution does the work on the web server, his solution does it on the DB server.
Josh
In my original post I NEVER said where this code could be used whether on the web server or DB server. Furthermore, I mentioned that the standard sort routines used in a DB server can be overiden and the supoopsed code can be used. So, the question of efficiency is mute. My solution will work anywhere you want it to. Another reason the the socalled efficency arguement is mute is that the web-server is calling the db-server that is actually doing all the work. As for Marcello attitude I personally could care less. All I wanted to do is help and pointed to a simple fact that the sort routine for the data is easy enough to implement. It is not always good enough to use just built-ins. Which I assume is the case. The matter of fact remains that the proper sorting can be easily achieved anywhere in the system with out any overhead. Position it where you want. I have programmed just such a situation and had no overhead. the database that was acessed via a web-server was set so that no new sorting or indexing was required when the db was called. I do know what I am doing an what can be done.