Skip to main content
January 30, 2009
Question

cf 8 .net

  • January 30, 2009
  • 1 reply
  • 766 views
Hi i 2 question re cf 8

1. is it possible to create a asp.net user control and then call it via cfinclude?

2. i have a scheduled task running every 61 seconds, this task loops through a sql server database table and for each record it posts info to a xml url, then deletes that current record.

this works fine, but i am started to sometimes get up to 10,000 records inserted at one time which can be slow, i am just wondering if there is a better way to do this, ie is schedule task the way to go?

basically any record that gets inserted into this table must be then posted as xml then deleted.

i was wondering if i could do somethig sql side of things? i am using sql express 2008
This topic has been closed for replies.

1 reply

Inspiring
January 30, 2009
craiglaw98 wrote:

>
> i was wondering if i could do somethig sql side of things? i am using sql
> express 2008
>

I do not know explicitly for SQL Express 2008, but yes many modern
Database Management Systems have the ability to out XML directly. I am
sure it would be worth checking with some SQL Express 2008 documentation
or resources to see if it is one.

January 30, 2009
Hi is there a better way to handle this task?

basically what i need is this

1. if there are any entries in the table send out an xml file to a url
2. then delete the current row

10,000 records takes a long time, i need to speed this process up somehow?
Inspiring
January 30, 2009
Can you post your code, including database structure if applicable?