Thursday 25 August 2005 9:30:24 am
I tested the patch from eZ Systems and it works: the errors have disappear with Apache 2 and I can connect to administration interface without problems. My guess regarding the multithreading were wrong I think, eZ Systems knows better what it was. I tested Oracle extension on several systems, here is the "biggest" one:
Version: 3.6.0 (3.6.0) SVN revision: 11973
Biprocessors Xeon 3 GHz
Memory: 2GB Apache/1.3.33 (Win32) PHP/4.3.9 mod_jk/1.2.14 PHP extensions standard, bcmath, calendar, ctype, com, ftp, mysql, odbc, overload, pcre, session, tokenizer, xml, wddx, zlib, apache, mbstring, oci8, Turck MMCache Oracle: Oracle9i Release 9.2.0.4.0 - Production How long it gets to load first admin page
Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.0647 sec 2.4232% 12 0.0054 sec
oracle_total
Oracle_queries 0.0080 sec 0.2995% 10 0.0008 sec
Oracle looping results 0.0044 sec 0.1651% 10 0.0004 sec
Template Total 0.2261 sec 8.5% 2 0.1130 sec
Template load 0.0309 sec 1.1569% 2 0.0154 sec
Template processing 0.1947 sec 7.2936% 2 0.0973 sec
override
Cache load 0.0219 sec 0.8222% 2 0.0110 sec
Total script time: 2.6690 sec
Oracle queries time is 0.0080
Mysql queries time was 1.100 (roughly) The others figures are comparable.
I faced three issues during with this extension:
1) the bug here above
2) a small bug in the sequence updating script (I was able to fix it myself) 3) a bug related to the char encoding (I think) of MySQL and Oracle: I got Oracle TWO-TASK ERROR (ORA-03106) when exporting data from MySQL to Oracle. For the rest everything's fine ... well don't forget to put character in the workflow event description (if not you'll have a "cannot insert null" but that's a detail). Hope this helps.
|