Forum Stats

  • 3,814,871 Users
  • 2,258,922 Discussions
  • 7,892,882 Comments

Discussions

ODAC 12.1.0.24 performance issue

3266817
3266817 Member Posts: 2
edited Jun 29, 2016 6:22AM in ODBC

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

Answers

This discussion has been closed.