OT : Good XP Domain Admin book?

It's only standard SQL if it's been coded as such - which would result
in a crippled system.

--
Krusty.

http://www.muddystuff.co.uk
http://www.muddystuff.us
Off-road classifieds

'02 MV Senna '96 Tiger '79 Fantic 250

 

hahahahahahahahahahahahaha

 

well, there is that.

Oh, I thought we were talking about portability, not performance. Sure,
if you want to tune the nuts off something, and can afford the app and
DB developer time to do so then yes, SPs are the way to go.

Sorta, kinda. I guess the thing with SPs is that they're OK if the
person doing the porting from one RDBMS to another knows both well -
also documentation is a Good Thnig.

 

Personally I'd do RDBMS-specific stored procs, a standard front end
with procedure calls, & a middle tier to convert those calls as
required. But I always was an awkward sod.

--
Krusty.

http://www.muddystuff.co.uk
http://www.muddystuff.us
Off-road classifieds

'02 MV Senna '96 Tiger '79 Fantic 250

 

But but but apparently they're all the same!

 

you're obviously old.

 

Older than I used to be, for sure. But the systems I work on would be
unusable without PL/T-SQL. Hence I've got my "it's very complex &
performance is paramount" hat on.

I blame frag - where's the bloody spec, hmmm?

--
Krusty.

http://www.muddystuff.co.uk
http://www.muddystuff.us
Off-road classifieds

'02 MV Senna '96 Tiger '79 Fantic 250

 

On the plus side, there are so few databases worth bothering with, that
coding for platform independence is something of a fool's errand.

 

Do the railwaye use platform-independent stuff?

 

Hmm, I'm not so sure. The statement-parsing overhead is eliminated if you
use SPs, but most databases have some form of statement caching these days,
and in any case the overhead is often very small compared with actually
fetching the data/doing the update

SPs are generally better from a security standpoint, though - and using them
can lead to better SQL being written (mainly as a result of leaving the
SQL-writing to database-type-people as opposed to Java/C# coders)

 

Or just use Hibernate and HQL ...

 

I think The Railways use Oracle[1]

[1] a mate of mine is working on a project where a train drives round the
entire railway network with video cameras looking in front, down at the
track, and to the left and right. Still images are taken every few seconds
and stored in a database along with the GPS coordinates. This is because
Railtrack/SRA/whoever don't actually know where all their infrastructure is
(or, indeed, what it is). It'd be a trainspotter's delight ...

 

It might have been Sweller, but I remember somebody telling me that BR
couldn't locate some carriages they'd 'misplaced' and ended up having to
ask the train spotting community if the knew where they were.

 

well, yeah. The app I was thinking of when I wrote the above is a J2EE
app, which doesn't use EJBs, but does use Struts as a framework and
Scaffold as a DB layer - everything but everything's nicely in the XML
config files, and it's very easily extensible.

 

http://www.dummies.com/WileyCDA/DummiesTitle/productCd-076450682X,subcat-NETWORKING.html


--
Steve Parry
K100RS SE & F650
and a 520i SE Touring for comfort


(not forgetting the SK90PY)

http://www.gwynfryn.co.uk

 

<one man bandit>
Servers? We ain't got no steenkin' servers.

--

Dave

GS850 x2 XS650SE / SE 6a

I demand nothing of you except that you amuse me.

 

CT scribbled:

Well they wanted a software engineer. And thats me.

And there's no one else with IT knowledge there, so its me doing
everything, s/e developer, IT network admin, management advisor...

But it ain't paying anywhere *near* £200k!

 

MikeH scribbled:

Fnar! But there's a tiny hint of truth in there

 

dwb scribbled:

Well, I have extensive knowledge of setting up and administering linux.

Its free. The current MS server only has a client limit of 10 and they
need more. And its clapped out and a new server needs to be built.

 

Mups scribbled:

Far from it. Cobbled together by someone who knows as much as I do.

There's so many problems with them its going to take a while to sort
out.

Cause I can do it, know how, and the s/w and apps are free.