After 2 years of this kind of performance, I'm about to flip :mad:
An Oracle 8i database, over a 100Mb network:
http://www.vbforums.com/attachment.p...postid=1154786
Printable View
After 2 years of this kind of performance, I'm about to flip :mad:
An Oracle 8i database, over a 100Mb network:
http://www.vbforums.com/attachment.p...postid=1154786
Perfect timing to have a *** :)
I stopped smoking during the day. Have my first *** at 6pm :cool:
The performance - It's one of the reasons I'm on here so long sometimes.... I mean, that's one row every 2 seconds!!!! :eek:
That's terrible, suggest upgrading from 286 :p
Excuses, excuses. We all know it's your sh*t code :P
td.
ouch :p
Look, he's run away now, the big girl.
td.
Thats what happens when you wing it;)Quote:
Originally posted by Gaffer
After 2 years of this kind of performance, I'm about to flip :mad:
An Oracle 8i database, over a 100Mb network:
http://www.vbforums.com/attachment.p...postid=1154786
Quote:
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... :p
But I thought you were an access programmer gaf ?
:) :) :)
Lol!
td.
LOL :D 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... :p
Quote:
Originally posted by Gaffer
LOL :D 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... :p
ooohhhwwww..
So whichever way you look at it, the response times are down to you then (if you wrote the SQL..:p )...
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....:rolleyes:
Yeah, it's amazing how complicated these Select * from.... statements can be :pQuote:
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..:p )...
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....:rolleyes:
Are you a sausage programmer now then???
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 :)
fikkin close fikkin to it I can tellya. fikkin fikkin fikkin...Quote:
Originally posted by Gaffer
Yeah, it's amazing how complicated these Select * from.... statements can be :p
Are you a sausage programmer now then???
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 !!! :rolleyes:
I'll gives ya one warning THINK THRICE before you leave the dizzy world of ocntracting mate... the $$$ drop is fkin agony !!!!!!
Peeman....
Funny that crispin, I get this email every day from my boss:
anythink we can do gaf ? Send 'em boyz round ?....quick course in Select * technologies ??
I won't even think once about it mate! You sufferingt? I hear things are picking up a wee bit....Quote:
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 !!! :rolleyes:
I'll gives ya one warning THINK THRICE before you leave the dizzy world of ocntracting mate... the $$$ drop is fkin agony !!!!!!
Peeman....
This db is on a WAN to the states, but it's never been as slow as it has been recently....
Suffrin ? Moi ?Quote:
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....
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.
Yeah all stored procs - no GUI or client side.
What's the call? whaddyamean?
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...
:D
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.Quote:
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...
:D
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... :rolleyes:
So all your DB tuning etc is dba controlled then ? you can't change your sps /views ?Quote:
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... :rolleyes:
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....