But when you do an upper or lower in your where clause does it not first apply that function to all values in that database column then it limits on whatever you had in the where clause? I know in Oracle if you lack a function based index and have a lot of records that will be a pretty big performance hit. By a lot of records I do mean in the millions though, since that is when I saw the problem happen. How does MSSQL handle case insensitivity? Behind the scenes is it just doing a upper or lower function?
On Mon, Jun 2, 2008 at 5:11 PM, Wil Genovese <[EMAIL PROTECTED]> wrote: > Russ, > > Case insensitive is easily solved using the lower or upper function > and for the "like" function there is "iLike" which ignores case. > Also, anyone can do high availability with PostgreSQL. However, there > is a learning curve (that I have not climbed yet) without paying > someone. But, there are plenty of pay PostgreSQL providers to help as > well. > > I run PostgreSQL exclusively for my own sites ( > http://beta.christianmp3.com > is one) and I have converted BlogCFC to use PostgreSQL. There are > very few differences to overcome. > > Check this out for HA and clustering. > http://pgcluster.projects.postgresql.org/ > > > Wil Genovese > > One man with courage makes a majority. > -Andrew Jackson > > A fine is a tax for doing wrong. A tax is a fine for doing well. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
