Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^3: OT: Sql statement (how to ignore lower-upper case)

by pelagic (Priest)
on Dec 15, 2004 at 14:46 UTC ( #415034=note: print w/replies, xml ) Need Help??


in reply to Re^2: OT: Sql statement (how to ignore lower-upper case)
in thread OT: Sql statemet (how to ignore lower-upper case)

Interesting!
Even Oracle got their Funcion Based Index. If you know in advance that you will be using something like that, it helps a lot!

pelagic
  • Comment on Re^3: OT: Sql statement (how to ignore lower-upper case)

Replies are listed 'Best First'.
Re^4: OT: Sql statement (how to ignore lower-upper case)
by thor (Priest) on Dec 16, 2004 at 04:31 UTC
    From reading the doc, it is of significant note that it's expensive to maintain that index, as it needs to be re-computed for every insert and update. It's not something to take lightly. However, it might make sense to do this on a relatively static database, or one in which the maintainence time is irrelevant, but access time is key.

    thor

    Feel the white light, the light within
    Be your own disciple, fan the sparks of will
    For all of us waiting, your kingdom will come

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://415034]
help
Chatterbox?
[1nickt]: Now that one made me hopeful! First time not angry in a long time when I saw that kid.
[Discipulus]: i propend for removing: why? because we are so few that we must find i minimal common divisor, this is certainly Perl not our (anyway private) thougths. And i say this still wondering because i love a lot freedom of expression. And i say this not for roho
[1nickt]: Discipulus that was the point of my story of taking the sticker off my truck. I know there are lots of people in the world who if I knw their private beliefs I might want to argue with them. And they with me. But life cannot all be arguments!
[1nickt]: This is less than perfect ... but demanding perfection (from people or from life) is a sure way to unhappiness.
[Discipulus]: and anyway we have CB where every (democratic) opinion can be expressed
erix eat the rich!
[1nickt]: I do think it is sad that roho has received 3 downvotes for his polite request, as did I when I objected to the profanity in stonecolddevin's sig. I upvoted both him and Karl for the discussion. Way too much downvoting for inappropriate reasons here!
Discipulus learn that 'argue' has a little negative sense, he thought was a neutral sense, 'vox media'
[1nickt]: argue == discuss && argue == be contentious
[Discipulus]: you are right 1nickt i didnt voted nor downvoted; I just upvote perl content i like

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (7)
As of 2017-06-22 12:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (519 votes). Check out past polls.