Hi,
When i'm doing the query "SELECT COUNT(*) FROM MY_TABLE" (whatever which table is "MY_TABLE") the HXTT driver read the entire table.
In our case the table is about 200Mo, highly fragmented and accessed on a network drive so it takes a lot of time.
It is possible to obtain the number of rows in a table with metadata stored on Access database (as do the Jackcess Java Library) ?
Thank you.
|
select reccount() from my_table;
|