Rob
I sent your updated code to you via email
Sam
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
Posted this yesterday but seems to have disappeared and not come to the list
:-s
Afternoon Guys,
I publish a web service which receives statistical data in an array of complex
objects from clients. This data then gets processed and inserted into a SQL
Server db to be reported from at a
describing.
Adrian
-Original Message-
From: Robert Rawlins [mailto:robert.rawl...@thinkbluemedia.co.uk]
Sent: 10 January 2009 11:41
To: cf-talk
Subject: Loading data from a webservice call into MSSQL.
Posted this yesterday but seems to have disappeared and not come to the
list :-s
[mailto:robert.rawl...@thinkbluemedia.co.uk]
Sent: 10 January 2009 11:41
To: cf-talk
Subject: Loading data from a webservice call into MSSQL.
Posted this yesterday but seems to have disappeared and not come to
the
list :-s
Afternoon Guys,
I publish a web service which receives
Posted this yesterday but seems to have disappeared and not come to
the list :-s
Afternoon Guys,
I publish a web service which receives statistical data in an array of
complex objects from clients. This data then gets processed and
inserted into a SQL Server db to be reported from
Hi Sam,
You should be able to create an in memory query to represent the
received data (your temp 'table' is rows and columns, same as a
'query'), and then your other operations would proceed normally with a
few minor changes in syntax, change the datasource= to dbtype=)
Ok, so you're
Hi Sam,
You should be able to create an in memory query to represent the
received data (your temp 'table' is rows and columns, same as a
'query'), and then your other operations would proceed normally with
a
few minor changes in syntax, change the datasource= to dbtype=)
Ok, so
That sounds fair about the disk I/O, we have contingency built into
the client applications so that if an exception is thrown by the web
service then the client will reattempt to upload the records in its
next request so the odd error every now and then is not essential but
I'm looking to
Hi Sam,
Oh, and the relative lifetime of these objects drops significantly as
well.
the disk table is going to last for LOTS of milliseconds (10ms per I/O
at least, times too many to count). here you won't incur ANY I/O
unless paging gets involved.
so you reduce the elapsed time by
9 matches
Mail list logo