tag:blogger.com,1999:blog-5215551487816981140.post6328050699702092196..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Stress Testing Oracle XE 10gMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-5215551487816981140.post-39787351527261986282014-01-27T01:28:46.155-08:002014-01-27T01:28:46.155-08:00Great piece of information,
Thanks for this.Great piece of information,<br /><br />Thanks for this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-65081678119588909482012-04-18T00:33:53.027-07:002012-04-18T00:33:53.027-07:00Thanks dude, useful :)Thanks dude, useful :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-66247456398749634462011-03-11T08:13:54.063-08:002011-03-11T08:13:54.063-08:00@Oleg: Regarding your comparison of Facebook and A...@Oleg: Regarding your comparison of Facebook and Apex (at apex.oracle.com), I ran both through the YSlow plugin for Firefox.<br /><br />For the Facebook main page (http://www.facebook.com), you actually get a lot of Javascript and stylesheets as well:<br /><br />This page has 4 external Javascript scripts. Try combining them into one.<br />This page has 4 external stylesheets. Try combining them into one.<br /><br />For the Apex login page (http://apex.oracle.com/pls/apex/f?p=4550):<br /><br />This page has 8 external Javascript scripts. Try combining them into one.<br />This page has 3 external stylesheets. Try combining them into one.<br />This page has 19 external background images. Try combining them with CSS sprites.<br /><br />But additionally, you get this:<br /><br />Grade F on Add Expires headers <br /><br />There are 34 static components without a far-future expiration date.<br /><br />Grade F on Compress components with gzip<br /><br />There are 11 plain text components that should be sent compressed<br /><br /><br />I don't know why the folks at Oracle haven't configured Expires headers and Gzip compression, it would save them a lot of bandwidth (but I see that Larry is #5 on the Forbes list again, so maybe they don't care :-).<br /><br />Personally, I always set up Expires-headers for static content, as it vastly improves the perceived and actual speed of a site (and on IIS it takes 10 seconds to configure).<br /><br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-80727125095327540202011-03-07T12:08:12.831-08:002011-03-07T12:08:12.831-08:00Hi, I also performed some kind of stress testings ...Hi, I also performed some kind of stress testings of different web sites months ago with that Load Impact web site and found out that apex.oracle.com (i.e. apex itself) has too much jquery/js/css files to load even on the first page that makes it behave not in a good manner comparing to some industry standard web sites.<br /><br />My article:<br />http://dbswh.webhop.net//dbswh/f?p=BLOG:READ:0::::ARTICLE:96400346724530<br /><br />Regards,<br />OlegAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-62398118140275337832011-03-03T12:52:37.712-08:002011-03-03T12:52:37.712-08:00Morten,
WOW! Great post!
I always wonder, what wo...Morten,<br /><br />WOW! Great post!<br />I always wonder, what would be the concurrent connection limit for: Oracle 11R2 SE 4CPU RAC? Sounds interesting but I don't have the servers to test it.Algishttps://www.blogger.com/profile/01465209409777364676noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-31323265717286802272011-03-01T16:24:51.085-08:002011-03-01T16:24:51.085-08:00Great material. It is good to see some firm number...Great material. It is good to see some firm numbers on performance and scaling. thanksSydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-37001984912963716152011-03-01T10:49:57.514-08:002011-03-01T10:49:57.514-08:00@Roel: Yes, I agree, it's a good showcase for ...@Roel: Yes, I agree, it's a good showcase for the Apex framework too.<br /><br />@Dan: Why Java? PL/SQL is king! But seriously, I really don't see Java as essential to the XE database. It would only bloat up the installation size and require more memory to run. I'd rather see Oracle spend time on improving PL/SQL.<br /><br />@Jnowl: I don't think you can run mod_plsql with XE without paying for a database or app server license, which kind of defeats the point of using XE. The Embedded PL/SQL Gateway would probably suffer in terms of performance because all images must be served from the database (via XDB). But you could use Tomcat and the Apex Listener with XE, that should probably be comparable to IIS + Thoth Gateway + XE.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-16543373615404593362011-03-01T08:09:15.422-08:002011-03-01T08:09:15.422-08:00Fascinating.
Would be very interesting to see if...Fascinating. <br /><br />Would be very interesting to see if there are differences between Thoth Gateway, PL/SQL Gateway (DBMS_EPG), and mod_plsql vis a vis performance.jnowlhttps://www.blogger.com/profile/05339849328831302081noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-70571916358853140722011-03-01T06:20:52.431-08:002011-03-01T06:20:52.431-08:00Great post! I would love to see XE with a Java eng...Great post! I would love to see XE with a Java engine. It only makes sense now that Oracle owns it.Dan McGhanhttps://www.blogger.com/profile/13971112000913341546noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-25798941980502099002011-03-01T01:20:38.481-08:002011-03-01T01:20:38.481-08:00Very nice! But IMHO this stress test says more abo...Very nice! But IMHO this stress test says more about APEX than 10g itself: APEX is very very scalable - even with modest HW and the cheapest DB possible!Roelhttps://www.blogger.com/profile/03592016581410637420noreply@blogger.com