Why this query:
SELECT TOP 50 ID,name FROM 1_table WHERE ID < X ORDER BY ID DESC
executes in UniQuery (Devart Unidac for Delphi) very slow
but directly in access quickly.
Table has around 60k rows.
Should I turn off some option in UniQuery ?
Delphi + UniDac + Access – problem with simple query
Delphi + UniDac + Access – problem with simple query
Why this query:
SELECT TOP 50 ID,name FROM 1_table WHERE ID < X ORDER BY ID DESC
executes in UniQuery (Devart Unidac for Delphi) very slow
but directly in access quickly.
Table has around 60k rows.
Should I turn off some option in UniQuery ?
Delphi + UniDac + Access – problem with simple query
Why this query:
SELECT TOP 50 ID,name FROM 1_table WHERE ID < X ORDER BY ID DESC
executes in UniQuery (Devart Unidac for Delphi) very slow
but directly in access quickly.
Table has around 60k rows.
Should I turn off some option in UniQuery ?