Search:

Type: Posts; User: Chadnutz

Search: Search took 0.02 seconds.

  1. Replies
    13
    Views
    753

    Re: How can I buffer parameterized inserts?

    I missed 1 second once and 5 seconds once in a 21 hour run. I had my 1 Hz writes inside of a Using statement so I was making, writing, and breaking the SQL connection at 1 Hz. I think this is...
  2. Replies
    13
    Views
    753

    Re: How can I buffer parameterized inserts?

    That is what I am doing. When the program starts it connects to three databases and checks for the existence of a table. If any of the tables DNE, it creates one for that particular server. Then...
  3. Replies
    13
    Views
    753

    Re: How can I buffer parameterized inserts?

    Baseline test is working. After noon I will put it in a production system and then report back tomorrow with the results. As you can see from the graph below, any value that isn't 1 is missed. I...
  4. Replies
    13
    Views
    753

    Re: How can I buffer parameterized inserts?

    I couldn't find any examples for queuing up parameterized inserts so I need to roll my own. Right now I'm looking into thread safe queues because I could be enqueuing and dequeuing "simultaneously"....
  5. Replies
    13
    Views
    753

    Re: How can I buffer parameterized inserts?

    There is a lot more code in the current function to assign values to hundreds of parameters. I just didn't include it. Right now I have created a separate function that loops through processing a...
  6. Replies
    13
    Views
    753

    How can I buffer parameterized inserts?

    I have an application that writes data to SQL Express at 1 Hz and then data is then moved to two separate SQL servers at the end of a run.

    Every several hours something hangs up in the write. I...
  7. Replies
    3
    Views
    2,571

    Re: Random ColumnMapping Error on SQLBulkCopy

    Any ideas? I got it again last night.
  8. Replies
    3
    Views
    2,571

    Re: Random ColumnMapping Error on SQLBulkCopy

    The program is installed in 20 different test cells. I have a variable that does not change for each test cell which is the test cell identifier. For instance, BxxCyy test cell instance of my...
  9. Replies
    3
    Views
    2,571

    Random ColumnMapping Error on SQLBulkCopy

    I am getting a completely random column mapping error that is really throwing me for a loop. The destination table mapping does not change over time and is built with the exact same code as the...
  10. Re: Best Method to Build SQL Query for Single Table Data in Organized Blocks

    Thanks. That worked really well. It leads me to two more questions, however.

    When I do this I get one column which returns the max temp. How can I pull out other parameters that are not...
  11. Re: Best Method to Build SQL Query for Single Table Data in Organized Blocks

    A test cell pumps data to a table.
    A table has these columns (among others): RunNumber, CurrentCycle, CurrentMode, TimeInMode
    For organization purposes, a table has data organized into run numbers,...
  12. Replies
    15
    Views
    70,141

    Re: VB.Net TCP Client/Server

    Comment out any reference to Vaisala as it will not work unless you have that instrument.
  13. Best Method to Build SQL Query for Single Table Data in Organized Blocks

    It was hard to explain the organization of my table in blocks...

    My primary key is an always growing [RowCount].
    I have other columns called RunNumber, CurrentCycle, and CurrentMode.

    Let's say...
  14. Replies
    15
    Views
    70,141

    Re: VB.Net TCP Client/Server

    Hello. I am trying to implement this for a simple server that would have multiple clients and will serve 5 weather parameters in one tab-delimited string. Connection and sending data is no problem,...
Results 1 to 14 of 14



Click Here to Expand Forum to Full Width