On Wed, 18 Jun 2003, Cosimo Streppone wrote: > > Any gotchas I should be aware of? I have a very high performance > > requirements application (millions of hits/day) and I need to know the > > architecture can cope with it (the alternative being PostgreSQL). > > Sorry if I mention obvious things, but I know of: > > 1) lack of placeholders support with DBD::Sybase + Freetds layer. > I used freetds 0.53, but 0.61 had the same problem for me.
Ah, that explains why people are using unixODBC with the TDS driver instead. I assume that supports placeholders (?). Sounds like a bit of a showstopper to me! > 2) I wasn't able to use sql transactions in the same way > I normally do with postgresql/db2/informix/sybase/... > This could be due to my fault, SQL server version (?), > or other problems I couldn't track down. Any chance you can expand on that? I use transactions in the application heavily (it has been developed on PostgreSQL), and had feared this might be an area of contention. -- <!-- Matt --> <:->get a SMart net</:-> Spam trap - do not mail: [EMAIL PROTECTED]