Database Programming in 2002

**Gaffer** · Sep 2nd, 2002, 10:09 AM

After 2 years of this kind of performance, I'm about to flip

An Oracle 8i database, over a 100Mb network:

**Bonker Gudd** · Sep 2nd, 2002, 10:11 AM

Perfect timing to have a ***

**Gaffer** · Sep 2nd, 2002, 10:14 AM

I stopped smoking during the day. Have my first *** at 6pm

The performance - It's one of the reasons I'm on here so long sometimes.... I mean, that's one row every 2 seconds!!!!

**Bonker Gudd** · Sep 2nd, 2002, 10:38 AM

That's terrible, suggest upgrading from 286

**tumblingdown** · Sep 2nd, 2002, 10:50 AM

Excuses, excuses. We all know it's your sh*t code :P

td.

**Gandalf_Grey_** · Sep 2nd, 2002, 10:59 AM

ouch

**tumblingdown** · Sep 2nd, 2002, 11:02 AM

Look, he's run away now, the big girl.

td.

**RSINGH** · Sep 2nd, 2002, 12:43 PM

Originally posted by Gaffer
After 2 years of this kind of performance, I'm about to flip

An Oracle 8i database, over a 100Mb network:

Thats what happens when you wing it

**Gaffer** · Sep 3rd, 2002, 03:49 AM

Originally posted by tumblingdown
Look, he's run away now, the big girl.

td.

SQL> delete from myMates where particularmate = 'Cheeky_wee_fooker'

/waits another 5 years for td's response...

**FATBOYPEE** · Sep 3rd, 2002, 03:58 AM

But I thought you were an access programmer gaf ?

**tumblingdown** · Sep 3rd, 2002, 04:03 AM

Lol!

td.

**Gaffer** · Sep 3rd, 2002, 04:10 AM

LOL

got in first td..... :givesthefingers:

Peeman, except for Excel, I haven't touched a microsoft product at work for the last 2 years, (including VB). I started out using access, as it's one way non computer people like me can wing it.

Have been programming Oracle 8i databases using PLSQL since then....

...and moonlighting as the Milk Tray man...

**FATBOYPEE** · Sep 3rd, 2002, 04:22 AM

Originally posted by Gaffer
LOL got in first td..... :givesthefingers:

Peeman, except for Excel, I haven't touched a microsoft product at work for the last 2 years, (including VB). I started out using access, as it's one way non computer people like me can wing it.

Have been programming Oracle 8i databases using PLSQL since then....

...and moonlighting as the Milk Tray man...

ooohhhwwww..

So whichever way you look at it, the response times are down to you then (if you wrote the SQL..

)...

nah nah, don't gimme that connection & bandwidtch cobblers....

As for the milk tray man..... wearing a black polo neck sweater does not qualify you....

want a job ? You can do this... writing Apps to be deployed into Sausage factories.... TWO TIER mindyo; none of this distributed COM architecture for these boys, they just don't see the need....

**Gaffer** · Sep 3rd, 2002, 05:06 AM

Originally posted by FATBOYPEE
ooohhhwwww..

So whichever way you look at it, the response times are down to you then (if you wrote the SQL.. )...

nah nah, don't gimme that connection & bandwidtch cobblers....

As for the milk tray man..... wearing a black polo neck sweater does not qualify you....

want a job ? You can do this... writing Apps to be deployed into Sausage factories.... TWO TIER mindyo; none of this distributed COM architecture for these boys, they just don't see the need....

Yeah, it's amazing how complicated these Select * from.... statements can be

Are you a sausage programmer now then???

**crispin** · Sep 3rd, 2002, 05:13 AM

Don't feel bad Gaf - Ian and Duncan just told me that my code was ****e, so we can be peas in a pod m8

**FATBOYPEE** · Sep 3rd, 2002, 05:17 AM

Originally posted by Gaffer
Yeah, it's amazing how complicated these Select * from.... statements can be

Are you a sausage programmer now then???

fikkin close fikkin to it I can tellya. fikkin fikkin fikkin...

You laugh about Select * From...

but I came acroos just such a select on a real-time system just yesterday and they were asking why the app was slooowww it was across a WAN too !!!

I'll gives ya one warning THINK THRICE before you leave the dizzy world of ocntracting mate... the $$$ drop is fkin agony !!!!!!

Peeman....

**Gaffer** · Sep 3rd, 2002, 05:20 AM

Funny that crispin, I get this email every day from my boss:

**Gaffer** · Sep 3rd, 2002, 05:20 AM

**FATBOYPEE** · Sep 3rd, 2002, 05:22 AM

anythink we can do gaf ? Send 'em boyz round ?....quick course in Select * technologies ??

**Gaffer** · Sep 3rd, 2002, 05:23 AM

Originally posted by FATBOYPEE
fikkin close fikkin to it I can tellya. fikkin fikkin fikkin...

You laugh about Select * From...

but I came acroos just such a select on a real-time system just yesterday and they were asking why the app was slooowww it was across a WAN too !!!

I'll gives ya one warning THINK THRICE before you leave the dizzy world of ocntracting mate... the $$$ drop is fkin agony !!!!!!

Peeman....

I won't even think once about it mate! You sufferingt? I hear things are picking up a wee bit....

This db is on a WAN to the states, but it's never been as slow as it has been recently....

**FATBOYPEE** · Sep 3rd, 2002, 05:25 AM

Originally posted by Gaffer
I won't even think once about it mate! You sufferingt? I hear things are picking up a wee bit....

This db is on a WAN to the states, but it's never been as slow as it has been recently....

Suffrin ? Moi ?

You effi'n bet !!

I'm suffirn Noddy-IT exposure, lack of $$, having to pay Tax, missing my mates & The beer-filled life of Amsterdam....the works really...

scanning everyday for contracts to RUAFO........

As for the WAN to thE states, stupid q. really but where's the call ?

You're using Stored Procs ??

no clinet processing I take it ??

Peeman.

**Gaffer** · Sep 3rd, 2002, 06:05 AM

Yeah all stored procs - no GUI or client side.

What's the call? whaddyamean?

**FATBOYPEE** · Sep 3rd, 2002, 09:53 AM

Gaf,

Poxy Server in M.Mouse Industries has only just returned.

Wot I'm meaning is, your db instance is in the US, you're using some kind of tool for Oracle to Execute your SP's or wotever across the WAN ? No replication capability anywhere on route ?

Peeman...

only trying to help/ be nosey and get out of sausage programming for a bit...

**Gaffer** · Sep 3rd, 2002, 10:43 AM

Originally posted by FATBOYPEE
Gaf,

Poxy Server in M.Mouse Industries has only just returned.

Wot I'm meaning is, your db instance is in the US, you're using some kind of tool for Oracle to Execute your SP's or wotever across the WAN ? No replication capability anywhere on route ?

Peeman...

only trying to help/ be nosey and get out of sausage programming for a bit...

Yeah, db is in US, and no replication capabilities - we were hugely dissappointed to learn 18 months ago that the SMBC data centre was to be centralised in the US.

Now we have support before 1pm, the DBAs hands are tied as everything is US centric (even thought the the majority of international business is done in London), and everything is very strictly controlled. Everything is getting s..l..o..w..e..r, from network, to database access, to program deployment, even to getting passwords (5 weeks for a UNIX password - in a DEVELOPMENT environment).

I am indeed using a tool to construct/run SPs - unbeliebavbly Oracle to not provide one, so it's 3rd party...

**FATBOYPEE** · Sep 4th, 2002, 03:17 AM

Originally posted by Gaffer
Yeah, db is in US, and no replication capabilities - we were hugely dissappointed to learn 18 months ago that the SMBC data centre was to be centralised in the US.

Now we have support before 1pm, the DBAs hands are tied as everything is US centric (even thought the the majority of international business is done in London), and everything is very strictly controlled. Everything is getting s..l..o..w..e..r, from network, to database access, to program deployment, even to getting passwords (5 weeks for a UNIX password - in a DEVELOPMENT environment).

I am indeed using a tool to construct/run SPs - unbeliebavbly Oracle to not provide one, so it's 3rd party...

So all your DB tuning etc is dba controlled then ? you can't change your sps /views ?

There are certain tuning things you can do if you have'nt already (use of Hints ??...Select /*+ ALL_ROWS */ xyz from.....)....

or using tables of selected data to query from (thus reducing the wait while a complex query executes)....

Dont' eny you though.... May stick to Sausage code....

Peeman....

Thread: Database Programming in 2002

Thread Tools

Display

Database Programming in 2002

Re: Database Programming in 2002

Wots wiv the orickle ??

Posting Permissions