Martin Schreiber wrote:
>
> The times include fetching the whole resultset (packetrecords = -1) and
the
> population of the grid.
>
"
select * from clients;
"
with packetrecords = 100 -> 0.006s.
Martin
--
___
Lazarus mailing list
Lazarus@lists.laza
Am Samstag 06 August 2011, 23:41:03 schrieb Howard Lee Harkness:
> Now I'm seeing a very slow response to opening the main table, even
> with no dependent tables.
>
> I set the SQL in the TQuery, then do an open. It takes 4 to 6 seconds
> to populate the TDBGrid. When I was using PostgreSQL with t
Now I'm seeing a very slow response to opening the main table, even
with no dependent tables.
I set the SQL in the TQuery, then do an open. It takes 4 to 6 seconds
to populate the TDBGrid. When I was using PostgreSQL with the same
database, it was instant.
qClients.Close;
qClients.SQL.Text:='
