Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

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

by pelagic (Priest)
on Dec 15, 2004 at 14:46 UTC ( [id://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

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://415034]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2024-04-19 16:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found