MySQL Performance: MySQL => Connecting to Mysql with ODBC vs C library

Members

Help

Home

Home » Performance » MySQL » Connecting to Mysql with ODBC vs C library

Show: Today's Messages :: Show Polls :: Message Navigator

Connecting to Mysql with ODBC vs C library [message #595]

Tue, 16 January 2007 01:51

geelwortel
Messages: 25
Registered: September 2006

Junior Member

Hi All

I read in the MySQL 5 study guide that if you connect to MySQL with the C library that this connection will be alot faster than connecting with the ODBC driver. How do I connect with the C library? If this is not posible what other way of connecting can I use that does not use the ODBC?

Thank you

Andrew

Report message to a moderator

Re: Connecting to Mysql with ODBC vs C library [message #596 is a reply to message #595 ]

Tue, 16 January 2007 04:20

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

This applies mainly to development.

If you're developing application use normal interface to MySQL, not ODBC. If it is third party application and it supports ODBC and native MySQL driver, use last one.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Connecting to Mysql with ODBC vs C library [message #597 is a reply to message #595 ]

Wed, 17 January 2007 02:58

geelwortel
Messages: 25
Registered: September 2006

Junior Member

Thanx for your reply Peter

I know this is more a development problem than a DBA function and I hope you can help me with this. My developer keeps on telling me that the C library connection is written specifically for .net connections and doesn't work well with C++ connections(our app is written in C++). All the manuals and documentation says that the connection works very well with C++. Is this true? Where can I get documentation about this that will help more for a developer than a DBA?

Thanx again for your help.

Andrew

Report message to a moderator

Re: Connecting to Mysql with ODBC vs C library [message #598 is a reply to message #597 ]

Wed, 17 January 2007 08:35

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

For .NET you should use native MySQL .NET connector not wrapper via ODBC.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Connecting to Mysql with ODBC vs C library [message #599 is a reply to message #595 ]

Wed, 17 January 2007 09:13

geelwortel
Messages: 25
Registered: September 2006

Junior Member

Our application is written in C++ and we are looking for a way to connect to MySQL that works beter/faster than the ODBC. ODBC gives alot of problems when we run big reports. What can we use?

Report message to a moderator

Re: Connecting to Mysql with ODBC vs C library [message #600 is a reply to message #599 ]

Wed, 17 January 2007 09:20

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

In this case you simply can use libmysql.

You developer is wrong. Connector .NET is completely different thing

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Connecting to Mysql with ODBC vs C library [message #635 is a reply to message #595 ]

Wed, 24 January 2007 20:11

ovidiub
Messages: 1
Registered: January 2007
Location: Romania

Junior Member

For C++ you could use: mysql++ (using MySQL C API)
http://tangentsoft.net/mysql++/

Ovidiu

Report message to a moderator

Previous Topic:	Performance Issue with Group by
Next Topic:	[solved] Performance using INT/SMALLINT

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 7 18:14:53 EST 2009

Total time taken to generate the page: 0.03510 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.