|
|
 |
 |
|
 Elite Fitness Bodybuilding, Anabolics, Diet, Life Extension, Wellness, Supplements, and Training Boards
 Chat & Conversation
 I hate oracle db's Wodin.
|
| Author | Topic: I hate oracle db's Wodin. | ||
|
Guru 
Posts: 3097 |
I have been kicked out of that damn thing more times than I have been laid in the last 6 months. What gives with this shit program?     | ||
|
Moderator
Posts: 1152 |
are you using odbc to access oracle or using something else? | ||
|
Guru
Posts: 3097 |
I am on an IBM RS6000, and working through a network. The program I use accesses odb to retrieve the info, I am not sure if it is odb or odbc. But it drives me nuts every time my program shuts down for no friggin' reason and it is slow as hell. | ||
|
Moderator
Posts: 1152 |
odbc is windows specific... i have limited experience on a rs6000. Do you know if you are local to the database, or are you accessing the database over a WAN? | ||
|
Guru
Posts: 3097 |
We are accessing it over a T3 type connection what the server is like I don't know, but it is definitely not local to me. They have a bezillion virtual drives all over the campus and the machine it is on I don't know about. I think it is just too much infor for oracle to handle. Our load cases can take up to 2 hours to download on a good day. | ||
|
Moderator
Posts: 1588 |
If you're accesing it across a T3 then it's not a bandwidth issue - so even if it isn't local it shouldn't matter. Oracle reuns really well on Unix systems but kind of struggles in other environments. | ||
|
Elite Bodybuilder 
Posts: 790 |
Totally agree matt. Our oracle platform is on a unix server that is web connected for daily output to various customer users on the net. On the inhouse side, we have everything hooked in through ms-access for users and we use the latest 4.0 + odbc drivers. For hardcore table crunching we use sql 7 since it has better drivers and setups. Our corp. envrionment, is MS-NT which can be a bit touchy at times, hence my three crashes yesterday. We use T3 lines as well accross the board. I would check with the net-work ops for specs on the server and see if it has dual or quad processors. Should at the very min be dual. | ||
|
Guru
Posts: 3097 |
Okay boys, this is Boeing, we're lucky if it has one processor. Were talking about the cheapest company on the planet. I don't know how large your files are, but ours can be in the gig range for just one loads file. If it is not oracle then it has to be our program that accessess the db, but the errors we always seem to get say segmentation fault or can't access the db or some shit like that. | ||
|
Elite Bodybuilder
Posts: 790 |
We receive and send out about 2.3 to 3.5 gig of data a day for customer accounts. This all has to go to a financial sett. process to a collective transmission company by 2:00 every day of the week. It usually streams at about 2.6 to 4.7 mb/sec so the problem for us is the servers not responding fast enough and data overflows. We are waiting for the 1.5 and 2.0 gig pentium III chips that are coming out this fall before we upgrade our server hardware. |
All times are ET (US) | |
 |
Powered by Infopop www.infopop.com © 2000
Ultimate Bulletin Board 5.45c
posted October 06, 2000 06:46 PM