How to use Relativity Server to access a huge database table?

Data Abstract
1

I’m using MSSQL with a database containing a few tables, one of them big and growing every day.
My Delphi client data module mapped all the tables, including that big table.
This table is the data source for a DevExpress Quantum Grid, but despite disabling the controls before opening the table, it takes a long time to open because it is loading all the records.
How can I enable paging?
I don’t remember having that kind of issue in the past.

The DevExpress TcxGrid supports a “server mode” that works for FireDAC and ADO directly connected to a MSSQL, Oracle, and other databases. Obviously, it doesn’t work with Data Abstract.

Do I have to do my own paging using TcxGrid events and WHERE conditions?

David

2

Hi,

You can use DASQL
It supports TOP and SKIP so you can get records of big table in small chunks.

example of DA SQL:

SELECT TOP 12 SKIP 13 *
FROM Employees e
ORDER BY e.EmployeeID