Zeoslib Portal

Just to be sure, it is this branch

https://sourceforge.net/p/zeoslib/code- ... sting-7.2/

right?

Hy Jan

Thank you very much for your answer and this great product!

Best Regards
slai

Hy There I'm struggling with the stable versions of zeoslib. in Sourceforge i see a download 7.2 release candidate, is this actually the stable 7.2? because i've seen that the 7.3 development already startet here: http://zeoslib.sourceforge.net/viewtopic.php?f=3&t=40782 so is the actually stable...

So, mainly the Performance Issues came from ZTable -> Refres, IndexFieldNames and Sorting. Is it correct that when i set SortType it imediatly begins with loading all datas and this SortType? Because i do first .refresh then setting SortedFields and then SortType. Now if 2 times refreshing then it i...

It's ok i do an internal refactoring to this, and will write my solution as soon as it performans as it should.

I know that it does not make really sense to do this on a big varchar field, but sometimes it is needed, because of many searches on that and so on, and the index statistic for that field gives me 0.00042... and that is a good value for an index and there are only 2900 Records in that Table. I've ch...

i found the problem, it has on the ZTable IndexFieldNames SBEZEICHNUNG ASC, this is a dbColumn with VARCHAR(500) and has an Ascending index on it. If i have this IndexFieldNames configured to SBEZEICHNUNG Asc then it takes about 12 seconds if i have nothin in IndexFieldNames then it takes under 1 se...

i did perfomance mesurements, i have 1 table adressstamm this needs about 12 seconds to activate the ztable: Can you see a problem from the ddl? CREATE TABLE ADRESSSTAMM ( ID BIGINT NOT NULL, IANREDE INTEGER, IPLZORT1 BIGINT, IPLZORT2 BIGINT, BMITARBEITER T_BOOLEAN_CHAR NOT NULL, BLIEFERANT T_BOOLEA...

I use DBDataMod.ZCDB.Properties.Add('codepage=UTF8'); so zeos codepage.

codepage is utf8 i also tried it with lazarus 0.9.28 because i have a project that runs only with that version correct at this momemt. But i have the same issue there. Maybe i have to do a huge refactoring to not use TZTable and only get the datas which i really need with zquery.

i use lazarus (fpc) 1.0.4 and zeos 7 with firebird 2.1 Transaction Level is set to RedCommited. Maybe FetchRow is what i need i'll do some tests now. What FetchRow Value would be the best for a Table, lets say of 1000 records, is there any formula of getting the best value?

is there any change in Zeos 7? I have a really big performance issue on refresh a table with many datas in it. I have several ZTables i open on starting the Programm and this is really slow, is there no possibility to only load the datas from the DB if really needed, and then just the records who ar...

it seems like it was shortly down, now it works.

Hy

Am i right that the actual SVN is https://zeoslib.svn.sourceforge.net/svn ... es/testing ?
I can browse the Source in Sourceforge but can't get access to the SVN url.

thx for reply!

Is this Problem already solved? i was trying to compile zeos from testing/trunk today and it failed with the same error: ZEOSDBO-7/src/core/ZClasses.pas(84,22) Error: No matching implementation for interface method "IUnknown.QueryInterface(constref TGuid,out <Formal type>):LongInt; CDecl;"...