MySQL ODBC 3.51驱动程序非常慢！ [英] MySQL ODBC 3.51 driver Very Slow!
问题描述
我使用MySQL ODBC 3.51驱动程序将三个相对较小的MySQL
表链接到Microsoft Access 2003数据库。我发现来自MySQL表格的数据需要花费很长时间来加载任何类型的链接
我的Access数据几乎没用。
我将MySQL驱动程序设置为USER DSN。 MySQL数据在服务器上是
，而Access数据库在本地运行。网络
连接非常好。
无论如何调整DSN以便更快地提取数据？
谢谢......
David J
DJJ写道：
< blockquote class =post_quotes>我使用MySQL ODBC 3.51驱动程序将三个相对较小的MySQL表连接到Microsoft Access 2003数据库。我发现来自MySQL表格的数据需要花费很长时间来加载任何类型的链接，而我的Access数据几乎没用。
我从未遇到访问速度和MySQL的问题，你是否已经
检查选项''只返回匹配的行''这是访问需要
（参见 http://dev.mysql.com /doc/mysql/en/msaccess-setup.html ）
你也可以尝试记录发生的事情，也许日志会给你
一些信息（我从未用过它）。可以跟踪
驱动程序调用，并且可以记录查询。
http://dev.mysql.com/doc/mysql/en/myodbc-trace.html
此处还有一个例子：
http://dev.mysql.com/doc/mysql/en/optimize-access.html
它包含优化Access以供使用的提示of mySQL。
Jonathan
-
答：因为它弄乱了人们通常的顺序阅读文字。
问：为什么这么糟糕？
A：热门帖子。
问：什么是最烦人的usenet和电子邮件中的东西？
" DJJ" < GE **** @ writme.com>在消息中写道
新闻：RD ***************** @ newssvr19.news.prodigy.co m ...我使用MySQL ODBC 3.51驱动程序将三个相对较小的MySQL表链接到Microsoft Access 2003数据库。我发现MySQL表中的数据
需要花费很长时间来加载任何类型的
与我的Access数据的链接几乎没用。
我有MySQL作为用户DSN设置驱动程序。 MySQL数据正在服务器上，Access数据库在本地运行。网络
连接非常好。
无论如何调整DSN以便更快地提取数据？
那个驱动程序并不慢！
我发现来自MySQL表的数据需要花费很长时间来加载。 ..
你提到你的（3）表格相对较小。如果您将
链接到小型MySQL表，它们通常会非常快速地加载。你需要
给我们一些关于你的设置的更多细节。有些东西不太正确
这里！
大（链接）表可能确实很慢。访问本身可能需要大量数据才能预先记录到记录集中。我希望
优先使用passthrough查询，绕过JET软件。 SELECT
* FROM SomeTable;"直接发送到MySQL将倾向于加载ADO记录集
比链接表快得多。特别是如果你可以使用
ForwardOnly记录集。当然这是一种单向负载。你需要一个
单独的直通查询来回写表格。
通过查询是一种非常有效的方法将MySQL服务器绑定到
MS Office系统。无论如何，ODBC 3.51驱动程序的问题是值得怀疑的。也许你可以提供更多细节？
Thomas Bartkus
非常感谢您的信息。
我设置了以下参数，但差别很小或没有。
不要优化色谱柱宽度
返回匹配行
允许大结果
使用压缩协议
在
数据表模式下加载并滚动到表格的最后一条记录需要16分钟，其中包含1319条记录，包括主键在内的40个字段。
我的网速是100 mpbs
我也尝试连接到我本地的同一个MySQL表的副本
我的机器在一个单独配置的DNS上它还是没有好多了。
所以绝对不是网络
DJJ
" Jonathan" <乔****** @ heelal.nl>在消息中写道
news：d7 ********** @ reader10.wxs.nl ...DJJ写道：
我使用MySQL ODBC 3.51驱动程序将三个相对较小的
MySQL表链接到Microsoft Access 2003数据库。我发现MySQL表中的数据
需要花费很长时间来加载任何类型的
与我的Access数据的链接几乎没用。
我从来没有遇到访问速度和MySQL的问题，你是否已经检查选项''只返回匹配的行''这是访问
所需的（参见 http://dev.mysql.com/doc/mysql/en/msaccess-setup.html ）
你也可以尝试记录正在发生的事情，也许日志会给你一些信息（我从未用过它）。可以跟踪
驱动程序调用，并且可以记录查询。
http://dev.mysql.com/doc/mysql/en/myodbc-trace.html
还有al ook here：
http：// dev.mysql.com/doc/mysql/en/optimize-access.html
它包含优化Access以使用mySQL的技巧。
Jonathan
- 答：A：因为它弄乱了人们通常阅读文字的顺序。
问：为什么这么糟糕？
A：顶部-posting。
问：usenet和电子邮件中最烦人的事情是什么？
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time to load making any kind linkage
with my Access data virtually useless.
I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting
out on a server and the Access database is running locally. The network
connection is very good.
Is there anyway to tweak the DSN so it pulls the data faster?
Thanks...
David J
DJJ wrote:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time to load making any kind linkage
with my Access data virtually useless.
I never had problems with the speed of access and MySQL, did you already
check the option ''return only matching rows'' This is needed for Access
(see http://dev.mysql.com/doc/mysql/en/msaccess-setup.html)
You can also try and log what is happening, maybe the log will give you
some information (I ''ve never used it thought). It is possible to trace
driver calls and it is possible to log queries.
http://dev.mysql.com/doc/mysql/en/myodbc-trace.html
Also have al ook here:
http://dev.mysql.com/doc/mysql/en/optimize-access.html
It contains tips to optimize Access for the use of mySQL .
Jonathan
--
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?
"DJJ" <ge****@writme.com> wrote in message
news:RD*****************@newssvr19.news.prodigy.co m...I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless.
I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting
out on a server and the Access database is running locally. The network
connection is very good.
Is there anyway to tweak the DSN so it pulls the data faster?
That driver is not slow!
I am finding that the data from
the MySQL tables takes a hell of a long time to load ...
You mention that your (3) tables are relatively small. If you are linking
to small MySQL tables, they will typically load very quickly. You need to
give us some more details about your setup. Something is not quite right
here!
Large (linked) table may indeed be slow. Access itself is probably
requireing an immense amount of data to xfer into a recordset upfront. I
preferentially use passthrough queries, bypassing the JET software. "SELECT
* FROM SomeTable;" sent directly to MySQL will tend to load an ADO recordset
quite a bit faster than a linked table. Particularly if you can use a
ForwardOnly recordset. Of course this is a one way load. You will need a
separate passthrough query to write back to the table.
Pass through queries are a very efficient way to bind a MySQL server to the
MS Office system. In any case, it is doubtful that the ODBC 3.51 driver is
the problem. Perhaps you could provide a bit more detail?
Thomas Bartkus
Thanks very much for the info.
I did setup the following parameters but with little or no difference.
Don''t Optimize Column Width
Return Matching Rows
Allow Big Results
Use Compressed Protocol
It takes 16 minutes to load and scroll to the last record of a table in
datasheet mode with 1319 records, 40 fields including a primary key.
My network speed is 100 mpbs
I also tried connecting to a copy of the same MySQL table I have locally on
my machine on a separately configured DNS and it was still not much better.
So it is definitely not the network
DJJ
"Jonathan" <jo******@heelal.nl> wrote in message
news:d7**********@reader10.wxs.nl...DJJ wrote:I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless.
I never had problems with the speed of access and MySQL, did you already
check the option ''return only matching rows'' This is needed for Access
(see http://dev.mysql.com/doc/mysql/en/msaccess-setup.html)
You can also try and log what is happening, maybe the log will give you
some information (I ''ve never used it thought). It is possible to trace
driver calls and it is possible to log queries.
http://dev.mysql.com/doc/mysql/en/myodbc-trace.html
Also have al ook here:
http://dev.mysql.com/doc/mysql/en/optimize-access.html
It contains tips to optimize Access for the use of mySQL .
Jonathan
--
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?
这篇关于MySQL ODBC 3.51驱动程序非常慢！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
