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.

cheers

martin.




Check out www.ubique.webscape.co.nz <http://www.ubique.webscape.co.nz/>
Ubique --> "Drives Your Business"

W E B S C A P E
PO Box 22571
25 Carlyle Street
Christchurch
http://www.webscape.co.nz <http://www.webscape.co.nz/>

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.
To: firebird-support@yahoogroups.com
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
illegal,
> right?

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

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


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .



=========================================================
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]