sql server 2000 problems saving

  • Hai all,

    in my application enter the data then these data is saved in 3 tables . in my application Records saved very slow why? i am using the sql server 2000 and .net and i am using the storeprocedures and 20 to 25 users are used and what is the problem? how to slove these probles.

    regards

    polaiah m

  • You have posted in an inappropriate forum. You would have gotten better results if you had posted in the appropriate forum.

    You also need to provide the code you are using, both VB and SQL.

    Please see the links in my signature to see how to post to get better answers.

  • The reason it takes a long time is because there is something wrong with it.

    Without more details about it, nobody can be more specific than that.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Ha! nice to see someone has a sense of humor :hehe:

    btw, the lead programmer here is still smarting over your suggestion he should "put his hands on the table and step away from the database" because he uses cursors

  • Heh... now THAT's funny!

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply