Search found 7 matches

by wiwiechris
10.03.2015, 11:15
Forum: ZeosLib 7.1 stable Forum
Topic: Performace issue "SELECT *" vs "SELECT col1, col2, col3....." (ORACLE)
Replies: 2
Views: 976

Re: Performace issue "SELECT *" vs "SELECT col1, col2, col3....." (ORACLE)

Hi Michal,

seems to be OK. ;-)
Thanks for your advice.

Best regards
Chris

ZEOS Version 7.1.4-Stable
ORACLE 11.2.0.1
Delphi 2010

Christoph Wiwie
http://www.wiwie.de
Certified Tester/ Certified Requirements Engineer
by wiwiechris
06.03.2015, 22:01
Forum: ZeosLib 7.2 Forum
Topic: Range check error
Replies: 7
Views: 2643

Re: Range check error

Hallo, I ran into the same error (Use code ZEOS 7.2 svn Revision 3619 with D2010). I think you found another example of a more general problem (See my postings in the 7.1.4-stable Forum). The point is that the compiler range checkings are switched OFF when the ZEOS-source is compiled and the compone...
by wiwiechris
05.03.2015, 11:11
Forum: ZeosLib 7.1 stable Forum
Topic: Performace issue "SELECT *" vs "SELECT col1, col2, col3....." (ORACLE)
Replies: 2
Views: 976

Performace issue "SELECT *" vs "SELECT col1, col2, col3....." (ORACLE)

Hallo @All I'am facing a strange performance problem (ORACLE) with ZEOS 7.1.4 My test-setup: * Have an ORACLE-table "MyTable" with 154 columns including over ten varchar2(200) columns (2000000 records) * "MyTable_INDEX" is a unique index on a NUMBER-column * Use TZQuery in ReadOn...
by wiwiechris
23.02.2015, 10:48
Forum: ZeosLib 7.1 stable Forum
Topic: Runtime-Error during (ORACLE) Unicode data selection (with activated D2010 Compiler Range-Check/Overflow checking)
Replies: 0
Views: 784

Runtime-Error during (ORACLE) Unicode data selection (with activated D2010 Compiler Range-Check/Overflow checking)

Hallo @All With D2010 activated range checking reading NULL -values from UNICODE columns causes a runtime error. My Test-Setup: * Have an ORACLE-Table "XY" with VARCHAR-column containing NULL-values * Add "ZEncoding.pas" (for debugging) to my project. * Activate Range checking an...
by wiwiechris
22.02.2015, 19:19
Forum: ZeosLib 7.1 stable Forum
Topic: Runtime-Error during ORACLE data selection (with activated D2010 Compiler Range-Check/Overflow checking)
Replies: 0
Views: 663

Runtime-Error during ORACLE data selection (with activated D2010 Compiler Range-Check/Overflow checking)

Hallo @All it seems that ORACLE-metadata are interpreted wrongly in some circumstances. My test-setup: * Have an ORACLE-table "XY" with "ColumnNameXY NUMBER(2)" * Activate range checking and overflow checking in the D2010 compiler * Make a select from table "XY" * Run i...
by wiwiechris
27.05.2014, 12:07
Forum: 6.6 - stable
Topic: windows 7 - SQLHourGlass - SLOW
Replies: 12
Views: 5919

Re: windows 7 - SQLHourGlass - SLOW

Hallo @All some observations regarding that issue: * The issue seems to persist in the 7.1.3stable code * Win7 32/64 Bit OS seems to be not the core reason (On a Win7 Home Premuim it "runs", on a Win7 Prof it "does not"). * In our environment setting SQLHourGlass to FALSE and set...
by wiwiechris
08.05.2014, 16:05
Forum: ZeosLib 7.1 stable Forum
Topic: Problem Updating NON-Cached ORACLE-Records
Replies: 0
Views: 1092

Problem Updating NON-Cached ORACLE-Records

Hallo @All there seems to be a problem retrieving the name of the Primary Key in an ORACLE environment. In the current implementation the Index name is retrieved by: Select ... FROM FROM ALL_INDEXES A, ALL_IND_COLUMNS B WHERE .... AND A.UNIQUENESS='UNIQUE' AND A.GENERATED=''Y''' AND A.INDEX_NAME LIK...