Zeoslib Portal

Hi, Seems like the problem is introduced with SVN revision 103 Actually, I wonder why something should happen when Sortedfields is emptied. Resorting seems odd to me. Does removing the Self.Internalrefresh call solve your problem? Mark Yes. The problem was gone. But I don't know the zeos internals ...

I found a problem in ZAbstractRODataset.pas. If I have in a TZQuery: CachedUpdates = true Filter = "" If a delete a record and change filter from empty to something then all changes are lost. The problem is here: if Active then {InternalSort;} {bangfauzan modification} if (FSortedFields = ...

Hello. I'm using zeos 6.5.1 with Delphi 7. If I set TransactIsolationLevel = tiReadCommited in the Connection, I always have a Transaction open. If I set TransactIsolationLevel to tiReadCommited just before open a transaction e and change back to tiNone after commit this don't happen. I think this i...

fduenas wrote:what is your zeos version and what database server are you using and what version? and what dll version ?

Zeos: 6.5.1 alpha CVS as of 13/10/2005
Postgres 8.1.4
libpq.dll 8.1.4.6142
Thanks.

Sorry for the delay. So I have some great problem. I think the problem is with the network or database config. My table with 6000 rows take > 30s to load in the network. My idea: with I have a table with the key and another in master-detail with all the data. When a navigate in the master, the detai...

The lookup fields use data in memory. I can't use SQL for them. The question is: Lookup is more slow than calc fields? A Zquery with "select * from table" is more fast than a Ztable? The table in question is customers. Have 6000 rows. And I have another table with some extra data, like a m...

swierzbicki wrote:Please be more precise.

What Database are you running ? , you can compress the data when running on MySQL.

How optimized is your SQL Query ?

Ops. Sorry.
I'm using Postgres. I'm using a TZTable. I need all the data for each row, but I need just one row each time. I need navigation(next, prior).

Hello. Somebody can help me to reduce the time needed to open a large database?
I know if a set Filtered to True this help.
Disable calc Fields? Lookup fields take much time?
Something else?
Thanks.