[thelist] Heavy-Duty Databasing?

"Burns, Martin" wrote:

> I think you're right here, although a number of application service
> providers will provide the fully managed service you're after, but
> to your specific specs. Have a look at http://www.exodus.com/
> 
> Dan, does Oracular do this kind of stuff? (albeit not on SQLServer;
> besides I think you're right about the NT thing, so I think Oracle's
> the solution anyway)

Yup we do, although I've never hawked my companies wares/services here..
And ya, I was also going to mention the strengths of Oracle compared to
SQL Server from MS, but that was getting a bit outside the scope of the
question and would probably best wait for another time :)

<tip type="ColdFusion Shortcut">
Anytime you can, let your DB do the work instead of Cold Fusion(or your
flavor of app. server). 
A good example of this is when one is getting a datestamp to insert into
the DB, something like #CreateODBCDateTime(Now)# is commonly used to get
the current time/date to insert into the DB.

A better way to do this would be to use one of Oracle's pre-defined
functions for the situation. In this case, the 'sysdate' function would
insert the current time/date into a field for you, and is always much
much faster than having CF do it. Example:

update foo set swinger='yes', martini='double yes', currenttime=SYSDATE
where user='djc'

Although SYSDATE is Oracle specific, I'm sure MS SQL Server has a
comparative feature.
</tip>

.djc.