Hi Marcello, As you evidently do not know even the slightest about dbase systems I will stop responding to your arguments. I will repeat I was using pseudo-code so you could use what ever is approriate for the task. The basic algorithm wil work with any kind of data or structures for that matter. All that is need is an appropriate cardnal function. You have fail to realize this. Also, I do not what kind of server system you are using, but I have known system that can handle "ö" for decades. Like I said you are not evidently qualified to partake in this discussion. regards Keith. Am 24.09.2009 um 13:00 schrieb Marcello Perathoner:
Keith J. Schultz wrote:
In my original post I NEVER said where this code could be used whether on the web server or DB server.
If you intended your code to be run on the database server, it would be an even more incredibly stupid thing to do.
If you want to influence the database server, then you must not write a routine that *compares* strings, but a routine that *transforms* strings:
If you wanted to sort like German phonebooks do, that is: to sort 'ö' as 'oe', then you would write a routine that substitutes all 'ö's in your input with 'oe's. Then you would feed the transformed string to the index table while feeding the original string to the data table. Voilà.
Of course you would have to transform all search terms in the same fashion too, because databases do most of the work on index tables and reach out to the data tables only when they really really really need to.
Furthermore, I mentioned that the standard sort routines used in a DB server can be overiden and the supoopsed code can be used.
How would you know? You don't even know which database we are using.
My solution will work anywhere you want it to.
Your `solution´ didn't even work on paper. I found 3 fat bugs just on a first eyeball revue.
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.
You programmed a small in-house application that gets hit a dozen times a day. In your situation you can get away with any amount of programming sloppiness because the hardware is so much superior to the task.
I am running a site that gets more than 1 Megahits a day, serving more than 70,000 customers per day.
Failure to consider scalability issues is another telltale sign of the rookie.
-- Marcello Perathoner webmaster@gutenberg.org _______________________________________________ gutvol-d mailing list gutvol-d@lists.pglaf.org http://lists.pglaf.org/mailman/listinfo/gutvol-d