Database are a lot of fun (well to me they are), but they do a lot more than just queries. Learning every aspect of Oracle is fairly complex and takes years of experience. there's a reason why Oracle DBA's make big bucks. Most people will never use the high end features of Oracle. Things like realtime backup using multiple databases, shared memory, shared storage and various Oracle plug-ins. anyone that has worked with large complex schema's that are high normalized knows how hard it is to manage hundreds of gigs of data. Say you maintain a database for a large retail company and there's terabytes of data about everything from inventory to customer purchasing habits. MySql is great for light weight web applications, but it doesn't begin to touch on hardcore database driven applications. Another example, say you run a Tv listing site, and you get daily updates to 50 tables. The data for every market in the US per week is 500megs of data. Now obviously there are some things you want to update and others you don't. Managing large regular updates like these can be simple or very complicated. Take it to the extreme where you have realtime data. How do you handle a costant stream of data that's several megs per second? tuning JDBC in Oracle is considerably harder than mysql because oracle is designed to run on small and large systems. If you have a E10000 with 24 CPU's and 1 terabyte of memory, you have to tune the number of pool per process and so on. I've only had a little hardcore Oracle experience, so I only know how hard it is. I couldn't actually manage large Oracle installations without a senior DBA's help. when ever I need to tune oracle, I ask my Oracle DBA friends who have 8 yrs of exp for help. peter Erik Price <[EMAIL PROTECTED]> wrote:
Chong Yu Meng wrote: > As a rough > indicator (and I invite others to correct me), it takes : > > - 1 month to understand Oracle > - 2 weeks to get JDBC working the way you want Is this indicator specific to Oracle? I set up the MySQL JDBC driver and had working queries in a matter of hours. (I am not using complex database abstractions, simply submitting SQL queries with JDBC classes.) > - 1 week to learn about file i/o I'm not sure about the Java tutorial on this topic, but if you read the File I/O chapter of Bruce Eckel's "Thinking in Java" (which you can download at http://mindview.net/ ), you can have File I/O basics down in a couple of hours. (My thoughts) Erik --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------- Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
