David Peake, the APEX Product Manager, gave the first two presentations:
- The Latest and Greatest from Development
- APEX @ Oracle
The first of these was a tantalising glimpse at what will be in 3.2 (coming soon) and 4.0 (coming later this year hopefully). These are described in the APEX Statement of Direction, but we were able to see some of them in a live demo. I am particularly looking forward to 4.0 for its improved tabular forms, and for Dynamic Actions - i.e. a "rich client" experience without having to write any Javascript.
Dimitri Gielis and John Scott from Apex Evangelists both gave interesting presentations, on Charting in Apex and Dispelling Myths about APEX respectively. Dimitri's piqued my interest to go back and look at charts again, and John's provided a lot of useful ammo for fighting against the usual "Apex is just a power user toy" kind of myths.
There was also a presentation from Matt Nolan and Vincent Migue from e-DBA called "Using Apex to Expose your Business to the Web" - and their website is a fine example of that.
After a short Q&A forum, we all went to the local pub, which was a great opportunity to get to know some of these people a little better.
All in all, a great day out (good grief, how sad do I sound?!) and I'd definitely like to attend the next one, should there be one.
2 comments:
Hello Tony:
i have a problem... hope u can help.
listen, im using a table that has a clob column... over a year i do inserts without empty_clob's
intructions, but... even now im having very big performance troubles.
im doing the next:
into a package i have dinamic information and i have a variable called cuerpo and it type is cLOB.
then ... the clob variable (cuerpo) that has inside HTML code... and then, i make the next insert:
INSERT INTO cto_confirmacion
(fol_confirmacion,
cuerpo,
id_email,
folio_factura)
VALUES
(1,
cuerpo,
1,
20);
over a year... this doesnt have any problem... even now... is very very very slow... almost 7
seconds 4 operation before maybe less than a second.
i tried to change:
INSERT INTO Xtable
(fol,
cuerpo,
idX,
folio_X)
VALUES
(1,
empty_clob(),
1,
20);
inmmediatly
UPDATE Xtable
SET cuerpo = cuerpo
WHERE fol = 1
and the primary key is fol....
even then... is very very slow....
i dont know what to do... im very worried.
I have to say that the string into my clob variable has a length of almos 5000 characters... can this make a difference in the way to make inserts???
Thanks 4 anything.
Regards.
Mariah,
I'm sorry, but I don't have any ideas for you about your CLOB problem. Why not try posting a question on one of the many forums out there? e.g. forums.oracle.com, dbforums.com, stackoverflow.com to mention just 3 that I regularly visit.
Post a Comment