Zeoslib Portal

Michael, nice and big work! 1) "the generic resolver should add Catalog and Schema only of Supported" - hmm, could there really be a case when Schema or Catalog <> '' but driver doesn't support these properties? 2) Links "http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=71516&a...

In addition what's the cost of ... Well in this case it's hard to benchmark exactly these pieces but I tried with other classes (var obj: TBaseClass, TDescClass = class(TBaseClass), condition "if obj is TDescClass") and this variant happens to be 10 times slower: 178062 ops/sec vs 1602564...

Michael, the reason is to avoid code duplication. For me, it is much larger evil than slight performance loss (if it truly exists!) because changes to this code copies become a nightmare. Regarding the code, I checked ASM and there's no difference between 1-byte and 4-byte values. CPU registers are ...

Michael, yep, my quick fix was too quick. There are several comparisons that were true after column clearing and they executed some necessary actions. I tried commenting some conditions out and tests succeeded though another tests started failing

I don't see any significant slowdown. FB 2.5, 4000 records, following loop: while not ZQuery1.EOF do begin ZQuery1.Edit; ZQuery1.Fields[0].AsFloat:=ZQuery1.Fields[0].AsFloat+0.001; ZQuery1.Fields[1].AsString:=RandomString(10); ZQuery1.Post; ZQuery1.Next; end; -4062- 13810 13750 13689 AVG: 13749,67 -...

That's better! I'll take a look

miab3 wrote:@Fr0sT: Version 4109 seems to be around 10% slower than 4087 !!!!

This says nothing... details?

Test change: disable ClearColumn and call metadata loading before field creation. Could you guys run test suite with this modification? src/component/ZAbstractRODataset.pas | 4 ++++ src/dbc/ZDbcResultSetMetadata.pas | 3 ++- 2 files changed, 6 insertions(+), 1 deletion(-) diff --git a/src/component/Z...

I'm now examining the corresponding metadata/columninfo code and tend to agree. Currently there's a weird situation: RS.Open queries column data (probably incomplete/incorrect) and then occasionally LoadColumns is called that invokes Metadata query which loads correct column info for the current sta...

Well some things are ready. Those who are interested can check current process here: https://github.com/Fr0sT-Brutal/Zeos_dev/tree/tmp_Guids and play with test app. Done : - Query domain info when receiving metadata - Set Guid type to metadata column by type (Char(16)) or domain name - Read/write Gu...

Yep, you're right But when it is executed? I tried dropping TZStoredProc on a form and making it active but this method won't be called.

Wow, this is pretty smart!
So FB code seems to completely ignore metadata when creating ColumnInfo objects? I'd say it's not a right way. I think it needs a redesign to use metadata. It also will help to implement domain-based GUID type assignment. I'll do some experiments in this area

TZ*DatabaseMetadata.UncachedGetProcedureColumns methods are not called by any method in Zeos. Is it incomplete implementation or caller code was removed?

Sorry guys, I understand everyone wants to see release at last but I had to make a couple of commits to 7.2 to simplify metadata-related things I currently digging into to implement GUID support. These commits are just cosmetic and shouldn't affect anything.

Perfect