Ain't gonna happen...

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #237,856 by admin 12/13/05 12:20:18 AM Reply	Ain't gonna happen... We're HEAVILY invested in Oracle. HEAVILY. As in, most of the web pages are generated with PL/SQL... Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #237,860 by drewk 12/13/05 12:58:57 AM Reply	You know that phonograph label? The one with the dog with his head cocked to the side? That's what I did when I read that last line. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #237,861 by folkert 12/13/05 1:20:03 AM 12/13/05 1:20:23 AM Reply	The RCA label? "The Masters Voice" -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* Freedom is not FREE. Yeah, but 10s of Trillions of US Dollars? SELECT * FROM scog WHERE ethics > 0; 0 rows returned. Edited by folkert Dec. 13, 2005, 01:20:23 AM EST Expand All History
Post #237,862 by pwhysall 12/13/05 1:36:45 AM Reply	You know what that dog's thinking of, don't you? Database permissions. Peter [link\|http://www.no2id.net/\|Don't Let The Terrorists Win] [link\|http://www.kuro5hin.org\|There is no K5 Cabal] [link\|http://guildenstern.dyndns.org\|Home] Use P2P for legitimate purposes!
Post #237,864 by drewk 12/13/05 2:04:35 AM Reply	I fixed my permissions problem I got it put on the sysadmin's TODO list. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #237,868 by admin 12/13/05 8:22:57 AM Reply	I'm not too surprised [link\|http://www.unix.org.ua/orelly/oracle/webapp/ch07_01.htm\|http://www.unix.org....ebapp/ch07_01.htm] It's difficult to find an actual "this is what it is and what it does" page, especially from Oracle, without a lot of digging. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #237,891 by ben_tilly 12/13/05 1:03:54 PM Reply	I had to use that approach once, briefly Even though I was a pretty raw programmer at the time, it didn't take me long to figure out that it was easier to write valid HTML then autogenerate PL/SQL to write that than it was to write it directly in PL/SQL. OK, that was a long time ago (Oracle 7), but I remember being distinctly unimpressed by the environment. I also remember thinking that it was inherently going to be a scalability problem, putting everything into the database. If you offload at least something to webservers, then you can easily increase the number of webservers for that component, and hit database bottlenecks later. Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #237,931 by admin 12/13/05 5:02:44 PM Reply	As it turns out... The query performance behind the pages completely overshadows any hit from running HTML-producing PL/SQL. By orders of magnitude. Moving the page generation to the web servers, while a good idea for other reasons, just means that your page generation can run quickly but the queries are still just as slow, so there's no speed increase. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #237,944 by ben_tilly 12/13/05 6:23:29 PM Reply	I see your point but... performance on individual pages is very different than overall system throughput. In fact I would expect the usual webserver approach makes individual pages slower to generate (greater latency between webserver and database). What I was saying, though, is that I'd expect the overall system to be able to generate more pages/second. My two major areas of concern would be overall I/O throughput (HTML tends to be more data than query results) and CPU bottlenecks (Oracle loves to waste lots of CPU on spinlocks, generating very high loads). However this is all theoretical. I've never seen two equivalent systems created and benchmarked against each other. Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)

Oracle tuning question - (admin) - (23) - Dec. 12, 2005, 03:30:11 PM EST

Try doing it in JavaScript - (drewk) - (1) - Dec. 12, 2005, 03:41:55 PM EST

Attach the table to MS Access? -NT - (ChrisR) - Dec. 12, 2005, 06:14:54 PM EST

ln /dev/null /oradata/archive/redolog.log -NT - (boxley) - Dec. 12, 2005, 03:59:17 PM EST

Answers - (ben_tilly) - (13) - Dec. 12, 2005, 05:21:07 PM EST

Re: Answers - (admin) - (12) - Dec. 12, 2005, 05:48:34 PM EST

I talked to a real DBA - (ben_tilly) - (11) - Dec. 12, 2005, 08:33:56 PM EST

Re: I talked to a real DBA - (admin) - (10) - Dec. 12, 2005, 08:43:03 PM EST

If the data isn't critical, then put it in MySQL. - (ben_tilly) - (9) - Dec. 12, 2005, 09:09:35 PM EST

Ain't gonna happen... - (admin) - (8) - Dec. 13, 2005, 12:20:18 AM EST

You know that phonograph label? - (drewk) - (7) - Dec. 13, 2005, 12:58:57 AM EST

The RCA label? "The Masters Voice" -NT - (folkert) - Dec. 13, 2005, 01:20:23 AM EST

You know what that dog's thinking of, don't you? - (pwhysall) - (1) - Dec. 13, 2005, 01:36:45 AM EST

I fixed my permissions problem - (drewk) - Dec. 13, 2005, 02:04:35 AM EST

I'm not too surprised - (admin) - (3) - Dec. 13, 2005, 08:22:57 AM EST

I had to use that approach once, briefly - (ben_tilly) - (2) - Dec. 13, 2005, 01:03:54 PM EST

As it turns out... - (admin) - (1) - Dec. 13, 2005, 05:02:44 PM EST

I see your point but... - (ben_tilly) - Dec. 13, 2005, 06:23:29 PM EST

Need to have stats of what is happening. - (broomberg) - (5) - Dec. 12, 2005, 08:05:35 PM EST

That will take me a bit. - (admin) - (4) - Dec. 12, 2005, 08:36:10 PM EST

Re: That will take me a bit. - (broomberg) - (3) - Dec. 12, 2005, 09:25:38 PM EST

Sent you an email. -NT - (admin) - (2) - Dec. 13, 2005, 10:45:42 AM EST

Email had no DB info, was address stuff only -NT - (broomberg) - (1) - Dec. 13, 2005, 10:52:17 AM EST

Was just making sure before I sent it; sent. -NT - (admin) - Dec. 13, 2005, 11:47:40 AM EST

iwethey.org

Eiks taeae vittun homma nyt riitaeae taestae paeivaestae?
104 ms