Search found 2733 matches

by mdaems
12.04.2016, 10:04
Forum: ZeosLib 7.1 stable Forum
Topic: ZEOS DBO Installation
Replies: 1
Views: 1354

Re: ZEOS DBO Installation

Hi, This is a correct message. Only one package should be installed. The last one in the list. This is done this way to avoid you have to compile IDE related stuff into your programs even when you don't need it for your usage. eg. When making connections form a console program you don't need the vis...
by mdaems
26.05.2014, 13:26
Forum: Announcements
Topic: Ban and User deletion issues
Replies: 4
Views: 52135

Ban and User deletion issues

Hi, I'm unhappy I have to tell this board is under heavy attack of spammers. With the bad consequence I constantly risk to weed out rightfull users too by some bad clicking. Right now I know I already deleted a user with username 'ailson' and 'josimar.??'. I probably banned their IP's as well. Just ...
by mdaems
31.03.2014, 13:53
Forum: ZeosLib 7.1 stable Forum
Topic: TZQuery Filter with * problem
Replies: 3
Views: 1689

Re: TZQuery Filter with * problem

Hi,

I remember I recently wrote a quick (and therefore not complete) answer for this problem.
Have a look here : http://zeoslib.sourceforge.net/viewtopi ... 38&t=11288
I know, I ask some effort and hope you can fix it for us, but with our limited 'staff' this will take ages otherwise.

Mark
by mdaems
26.03.2014, 14:48
Forum: ZeosLib 7.0 Stable Forum
Topic: Zeos 7.0.3 TZTable; Huge memory consumption
Replies: 6
Views: 6696

Re: Zeos 7.0.3 TZTable; Huge memory consumption

Bad news. The table will be two times in memory.

Good luck!!

Mark
by mdaems
26.03.2014, 09:35
Forum: ZeosLib 7.0 Stable Forum
Topic: Zeos 7.0.3 TZTable; Huge memory consumption
Replies: 6
Views: 6696

Re: Zeos 7.0.3 TZTable; Huge memory consumption

Andy, ZQuery is almost the same as a TZTable. (Actualy, internally a ZTable is a ZQuery with the automated sql setting 'select * from <tablename>') As far as I know transforming a TZTable + filter to a TZQuery involves: Step 1 - remove tztable - add tzquery (eventually with identical name to avoid a...
by mdaems
25.03.2014, 21:12
Forum: ZeosLib 7.0 Stable Forum
Topic: Zeos 7.0.3 TZTable; Huge memory consumption
Replies: 6
Views: 6696

Re: Zeos 7.0.3 TZTable; Huge memory consumption

Andy, I'm afraid your approach is wrong from the beginning. Using TZTable you're effectively using the full tables, even if you only need some records. I suppose you use filters to limit the rows to the ones you effectively use? And sorting is done using TZTable property? Both are client-side operat...
by mdaems
25.03.2014, 20:49
Forum: ZeosLib 7.1 stable Forum
Topic: TZQuery.Filter problems
Replies: 2
Views: 1303

Re: TZQuery.Filter problems

Without deeper study I can't answer your first question. But try debugging the IsMatch function in core\ZMatchPattern.pas. For the second question: filters never become part of the query statement, so sql syntax doesn't work. You should give the result columns of your queries a unique name like SELE...
by mdaems
11.03.2014, 12:29
Forum: ZeosLib 7.2 Forum
Topic: Massive slowdowns due to SHOW TABLES and SHOW FULL COLUMNS
Replies: 9
Views: 7361

Re: Massive slowdowns due to SHOW TABLES and SHOW FULL COLUM

Well, what I actually wanted to say was that there shouldn't be metadata queries at all when 'after scroll requerying'. I think you misunderstood 'reopening a connection'. Because to requery a detail table you don't have to reopen the connection, just the query. So all queries using the same TZConne...
by mdaems
06.03.2014, 22:02
Forum: ZeosLib 7.2 Forum
Topic: Massive slowdowns due to SHOW TABLES and SHOW FULL COLUMNS
Replies: 9
Views: 7361

Re: Massive slowdowns due to SHOW TABLES and SHOW FULL COLUM

Actually, there is a metadata cache built into zeoslib. And it should only load data at first use. I haven't debugged it for a long time, so there might be caching bugs. The code should be driver independent, I believe. Just the way the data is retrieved depends on the driver. During one connection ...
by mdaems
06.03.2014, 08:49
Forum: SQLite
Topic: create database with sqlite
Replies: 4
Views: 3208

Re: create database with sqlite

Forum has moved, but topic idea should still be the same.

Mark
by mdaems
12.01.2014, 22:12
Forum: ZeosLib 7.1 stable Forum
Topic: PostgreSQL performance - CAPIPreparedStatement
Replies: 4
Views: 1084

Re: PostgreSQL performance - CAPIPreparedStatement

This is strange behavior indeed. did you try adding a zsqlmonitor to check if only one prepare is executed? Maybe the statement is not preparable for some reason.
by mdaems
28.12.2013, 17:29
Forum: 6.6 - stable
Topic: Support policy
Replies: 2
Views: 1693

Re: Support policy

Rabi, The text you are quoting is a few years old. In the meantime stable versions 7.0 and 7.1 are released. So now we effectively stopped supporting the 6.6 version. You only need that series when still using very old compilers (e.g. Delphi 5 or 6). For these compilers we can safely assume latest 6...
by mdaems
15.12.2013, 21:02
Forum: ZeosLib 7.2 Forum
Topic: Zeos 7.2 and CT
Replies: 12
Views: 4432

Re: Zeos 7.2 and CT

hi, you're more than welcome to tell us where the problem comes from. I must admit it also poses problems in my Lazarus installation. and for some reason I had to add new source paths to my buildscripts. I guess you found the reason. so, please tell us how you fixed it. maybe a Sun diff against the ...
by mdaems
25.11.2013, 21:12
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7860

Re: 0 record(s) updated. Only one record should have been up

SVN rev. 2948 (7.2-testing).
Can be merged to 7.1 soon.

I'm aware this patch is insufficient for IB/FB, but I need a user specialized in this databases to find out how this can be solved.

Mark
by mdaems
25.11.2013, 13:56
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7860

Re: 0 record(s) updated. Only one record should have been up

No, you don't need the interbase change in that case. I included it for completeness. Whether a re-install is necessary depends on your test case. If the full zeoslib source is on the search path it will be compiled automatically into your test program. Otherwise you'll have to re-install so the com...