Subject RE: AW: [firebird-support] Firebird vs. MS SQL Server
Author Martin Catherall
I normally work with MSSQL server although have been usinf firebird now
on a project for quite some time.
After initially finding some of the syntax odd, especially for selects,
I now find it quite good.

One comment I have through, I find the lack of support for xml hindering
at best, for example in MSSQL I can update thousatnds of rows at a time
based on a join to an xml fragment, XML is really good for passing
arrays to stored procedures.

If anybody can tell me a really good way to pass an array to a firebird
stored procedure then I would love to know.



Check out <>
Ubique --> "Drives Your Business"

PO Box 22571
25 Carlyle Street
Christchurch <>

Phone 03 964 4020
Fax 03 365 9115
Email mc@... <mailto:tmc@...>

-----Original Message-----
From: Rafael Szuminski [mailto:raf1hh@...]
Sent: Tuesday, 11 January 2005 8:51 a.m.
Subject: Re: AW: [firebird-support] Firebird vs. MS SQL Server

> 40 concurrent connections?
> How is this possible at all?
> And even if you can make MSDE use 40 connections, then this is
> right?

Actually it's not illigal. MSDE supports UNLIMITTED connections,
will just slow down each connection after the count reaches 8
concurrent batch processes. So I could have 200 connections open
any one point in time and if only one of those connections would
executing a batch process then the governor would never kick in.

Hey, I hate MSSQL as much as anybody in here :-), but the fact
that SQL is way more efficient with network bandwidth then FB1.5


Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to:

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <> .

This e-mail has been scanned for Viruses and Content and cleared by CommArc Cube Server

[Non-text portions of this message have been removed]