Subject | RE: AW: [firebird-support] Firebird vs. MS SQL Server |
---|---|
Author | Martin Catherall |
Post date | 2005-01-10T20:23:43Z |
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
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
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]
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?illegal,
> 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,
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]