We are using CF 4.5.1 SP2 on RedHat 6.2 with Sybase 11.9.2.
I'd be happy to share... What would you like to know?
So far it's been pretty smooth sailing.
One little snag was we were running Sybase in the default, case sensitive mode. It
caused some problems because the Cold Fusion drivers (inexplicitly) call a system
stored procedure called Sp_SeRvEr_InFo, which of course does not exist. Every once in
a while, specially when running many small queries in a row, Cold Fusion would try to
call this crazily capitalized stored procedure and get an error.
Allaire wouldn't acknowledge that this problem existed, which is pretty dumb since
they could just do a search and replace in their source code to change Sp_SeRvEr_InFo
into sp_server_info.
You can fix it in two ways: copy the text of sp_server_info to a new stored procedure
Sp_SeRvEr_InFo so that it DOES exist, or just change your default server-sort-order to
one that uses case-insensitive matching. Then all stored procedure names, table names,
column names, and data comparisons will be case insensitive.
Another issue is that the current Linux kernel does not have good support for
lightweight multi-threading, so the Sybase drivers are single threaded :-( We haven't
had any performance or stability problems due to this yet... but we are looking
forward to the new Linux kernel and new Sybase drivers that take advantage of the
better multi-threading support.
I'd also like to see raw disk device I/O so we could use a raw drive for the database
instead of a file system file...
Other than these... it's been easy to install, easy to administer, fast and
efficient...
At 09:28 PM 1/3/01 -0500, Marius Milosav wrote:
>and can share some info.
>
>I am interested in any problems, unusual setup procedures etc
>
>
>Thank you
>Marius Milosav
>www.scorpiosoft.com
>It's not about technology, it's about people.
>Virtual Help Desk Demo (VHD)
>www.scorpiosoft.com/vhd/login.cfm
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
