-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi, all.
According to Microsoft (http://www.microsoft.com/data), ODBC is in "Quick-Fix
Engineering" mode...meaning that only fixes for serious bugs are being
introduced into the standard. OLE-DB is their preferred method for accessing
SQL Server datasources (and is probably as close to a "native driver" as you
can get).
On a side note, we've had mixed success implementing OLE-DB datasources that
point to SQL Server in Cold Fusion, so ODBC datasources are still with us; but
going forward, OLE-DB is a good technology choice. More of SQL's advanced
features are available in OLE-DB.
In our limited performance comparisons, OLE-DB is only about 5-10% faster than
ODBC for straight DML (i.e no crazy hierarchical joins or even crazier DDL
statements).
Hope this helps!
Joe
============================================
Joseph Cruz
Wharton Computing and Information Technology
Programmer/Analyst
3620 Locust Walk
Suite 400 SH-DH
Philadelphia, PA 19104-6302
[EMAIL PROTECTED]
215-898-1220(w) 215-573-2798(f)
215-308-0657(p) 215-768-2071(m)
============================================
> -----Original Message-----
> From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 25, 2001 11:18 AM
> To: CF-Talk
> Subject: RE: ColdFusion FAQ
>
>
> > I have a question. Why do you say that OLEDB connection is
> > faster for SQL
> > server than ODBC? I always thought that ODBC is native to
> SQL servers.
>
> Can anyone give Xing the answer?
>
> Or is it wrong in the FAQ?
>
>
> --
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBOplHuNCGp5RuWHIBEQLj8wCdHb7sONJ7LkMi3RGUh1VDVBcxOykAoJm0
4DgLm4L5m57g0FGAPf3p0KGG
=6hjS
-----END PGP SIGNATURE-----
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
