Forum Replies Created

Viewing 15 posts - 16 through 30 (of 937 total)

  • RE: sql DB table handling thousands of inserts a sec

    Evil Kraig F (9/23/2011)


    Mike C (9/23/2011)


    Based on the OP's description it sounds like he's checking to see if the record exists first. Possibly via SELECT prior to INSERT.

    So here's a...

  • RE: sql DB table handling thousands of inserts a sec

    I just saw that getMD5hash myself. What exactly is the point of that field? In addition to what Kraig pointed out, if you absolutely need to populate this MD5 hash,...

  • RE: sql DB table handling thousands of inserts a sec

    SQL can guarantee the integrity of your individual SELECTs followed by INSERTs by itself, but it sounds like your .NET app is single-threaded? If that's the case the "tail-end" theory...

  • RE: sql DB table handling thousands of inserts a sec

    Elliott Whitlow (9/23/2011)


    Hundreds or even thousands per second isn't a lot really and if you are having timeouts I might say your existing hardware/structures are incorrectly spec'd. If you...

  • RE: sql DB table handling thousands of inserts a sec

    Based on the OP's description it sounds like he's checking to see if the record exists first. Possibly via SELECT prior to INSERT.

    So here's a question: assume a CI on...

  • RE: sql DB table handling thousands of inserts a sec

    Evil Kraig F (9/23/2011)


    You'll want to make sure your clustered index is controlled to try to append to the tail at almost all times. There's some other things you...

  • RE: sql DB table handling thousands of inserts a sec

    j_depp_99 (9/23/2011)


    I have a sql server 2008 database setup that accepts insert transactions from a visual studio application that is running using threads. If code detects a timeout, it will...

  • RE: A Google-like Full Text Search

    Hi Jonathan,

    I'll take a look at it. I've actually created an expression evaluator using Irony, but I'm interested in taking a look at how you approached it. One thing I'm...

  • RE: A Google-like Full Text Search

    Hi Jonathan,

    I recall our conversation, but I can't find our old email exchange (I recently had to restore my system, lost a big chunk of emails). I definitely like what...

  • RE: A Google-like Full Text Search

    laptop (6/26/2011)


    I was very interested in this article for my current project.

    However, I have two concerns about the approach taken. First, it relies on the Irony project, which is a...

  • RE: A Google-like Full Text Search

    Been a while since I've done anything with Classic ASP/VB, but it appears the only thing that DLL you were looking at is doing is storing a "table" of noise...

  • RE: A Google-like Full Text Search

    mbrading (5/17/2011)


    Hi Mike,

    Very sorry ... a different bookmark for a different download.

    This was an asp script doing a similar conversion job.

    Sorry to waste your time.

    Regards

    Matt

    No problem Matt. I'm still...

  • RE: A Google-like Full Text Search

    mbrading (5/17/2011)


    Definitely the right code Mike ...

    The first line in the global.asa file is the problem ...

    object id="NoiseWords" progid="IISSample.LookupTable" runat="Server" scope="Application"

    That progid is not valid on...

  • RE: A Google-like Full Text Search

    mbrading (5/16/2011)


    Hey Mike,

    Thanks for your help ...

    When I install the provided scripts, the global.asa file throws the follwonig error ..

    The object has an invalid...

  • RE: A Google-like Full Text Search

    Never heard of lkuptbl.dll. Can you be more specific with an exact error message, maybe the code that's causing problems?

Viewing 15 posts - 16 through 30 (of 937 total)