Search found 2733 matches
- 12.04.2016, 10:04
- Forum: ZeosLib 7.1 stable Forum
- Topic: ZEOS DBO Installation
- Replies: 1
- Views: 1394
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...
- 26.05.2014, 13:26
- Forum: Announcements
- Topic: Ban and User deletion issues
- Replies: 4
- Views: 52344
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 ...
- 31.03.2014, 13:53
- Forum: ZeosLib 7.1 stable Forum
- Topic: TZQuery Filter with * problem
- Replies: 3
- Views: 1742
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
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
- 26.03.2014, 14:48
- Forum: ZeosLib 7.0 Stable Forum
- Topic: Zeos 7.0.3 TZTable; Huge memory consumption
- Replies: 6
- Views: 6870
Re: Zeos 7.0.3 TZTable; Huge memory consumption
Bad news. The table will be two times in memory.
Good luck!!
Mark
Good luck!!
Mark
- 26.03.2014, 09:35
- Forum: ZeosLib 7.0 Stable Forum
- Topic: Zeos 7.0.3 TZTable; Huge memory consumption
- Replies: 6
- Views: 6870
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...
- 25.03.2014, 21:12
- Forum: ZeosLib 7.0 Stable Forum
- Topic: Zeos 7.0.3 TZTable; Huge memory consumption
- Replies: 6
- Views: 6870
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...
- 25.03.2014, 20:49
- Forum: ZeosLib 7.1 stable Forum
- Topic: TZQuery.Filter problems
- Replies: 2
- Views: 1357
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...
- 11.03.2014, 12:29
- Forum: ZeosLib 7.2 Forum
- Topic: Massive slowdowns due to SHOW TABLES and SHOW FULL COLUMNS
- Replies: 9
- Views: 7747
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...
- 06.03.2014, 22:02
- Forum: ZeosLib 7.2 Forum
- Topic: Massive slowdowns due to SHOW TABLES and SHOW FULL COLUMNS
- Replies: 9
- Views: 7747
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 ...
- 06.03.2014, 08:49
- Forum: SQLite
- Topic: create database with sqlite
- Replies: 4
- Views: 3376
Re: create database with sqlite
Forum has moved, but topic idea should still be the same.
Mark
Mark
- 12.01.2014, 22:12
- Forum: ZeosLib 7.1 stable Forum
- Topic: PostgreSQL performance - CAPIPreparedStatement
- Replies: 4
- Views: 1155
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.
- 28.12.2013, 17:29
- Forum: 6.6 - stable
- Topic: Support policy
- Replies: 2
- Views: 1787
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...
- 15.12.2013, 21:02
- Forum: ZeosLib 7.2 Forum
- Topic: Zeos 7.2 and CT
- Replies: 12
- Views: 4565
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 ...
- 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: 8173
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
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
- 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: 8173
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...