Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODAC 12.1.0.24 performance issue

3266817Jun 28 2016 — edited Jun 29 2016

Hi

I have a performance problem when I use linked table in Access 2016.

A huge table (~270 million rows, ~ 40 Gbyte tablesize) has been successfully imported, but when I tried to run a simple query (select top 10 *) the Access application goes to "not responding" status and I have to wait about 40 minutes.

It is work properly via Microsoft driver in Office 2007,  but in the new Office version it is not supported.

Is there any workaround or "best performance" settings to use huge table? (row limit or cache)

Kind Regards,

Gabor

Comments

Answer

With the MySQL 8.0 series, there are releases every three or so months that do include security updates. That is unless there is something urgent that needs to be updated.  Watch the release notes for updates https://dev.mysql.com/doc/relnotes/mysql/8.0/en/

Marked as Answer by 1045057 · Sep 27 2020

MySQL 8.0.16 was release on April 25th

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 27 2016
Added on Jun 28 2016
#odbc, #windows-and-net
2 comments
794 views