Post reply

Advice for Online and client-server application

  • January 19, 2009 at 7:51 am

    #217597

    Hi I have the following situation with a new application I will design for a distributor.

    They have sales people around the state and they need a way to enter orders from home.

    Also they need to enter orders in the main office.

    If the remote sales people enter orders in a Web based SQL server and the local people use a local Server SQL server.

    What is more efficient? To make the Web based server syncronize orders to the local based server? Tehy enter only around 120 order per day.

    or to eliminate the local server and only work with a web Server for both sides of the application? Is this going to be very slow for the local office?

    The application will be created in VB.NET with SQL Express 2005.

    Thanks in advance for your comments.

  • January 19, 2009 at 11:59 am

    #929343

    oook I get the point

    Thanks all 😛

  • January 20, 2009 at 12:50 pm

    #929914

    First, you were in way too much of a hurry for an answer, and second, you provided rather scant details on which to base an answer. Thus I suspect it's likely you're trying to design a solution that you may not really know how to design, and/or perhaps aren't willing to let the customer know you're in over your head.

    Despite those challenges, let's talk about what reasons you would have to even suggest a 2nd server, when it should be fairly obvious that for 120 orders per day, one server is more than adequate. Does this client have an existing web-facing infrastructure, along with the internal talent to secure it? Or is this a smaller company that simply doesn't have those resources? That alone might dictate where the server ought to be housed. Is there an existing SQL Server? Are there any client-specific concerns or inherent restrictions that come into play?

    You need to provide a lot more detail if you expect someone to be able to provide useful guidance. I'm fairly certain that's why no one was in any hurry to respond.

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • January 20, 2009 at 2:21 pm

    #929968

    Thanks Steve

    You just lost 5 minutes of your time with a smart-*ss answer.

    I know the Client server solution but I am not trained to create a web solution. I will find the answers somewhere. Not knowing is not the issue, is not being willing to learn.

    I just wanted to know if replication was faster.

    Thanks anyway and keep up with your great comments.

  • January 20, 2009 at 2:37 pm

    #929980

    Don't be so surprised that you get called out for leaving ALL of us hanging about what to do with your post. What, exactly, were you expecting? If we don't even know half as much about the situation as you do, how were you planning to get either viable advice or a workable result? If you felt put upon, then my apologies, but gee whiz, at least provide some indication that YOU at least have SOME understanding of what's needed. Your 1st message left me with the perception that you had no clue and were just fishing in the dark, and your 2nd one with the perception that you so desperately needed a miracle, that 4 hours was WAY too much time for us to respond in.

    Do you think that maybe WE might have felt "put upon" by your apparent impatience? What goes around, comes around...

    Steve

    (aka smunson)

    :w00t::w00t::w00t:

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • January 20, 2009 at 11:45 pm

    #930123

    jreyes (1/19/2009)

    Hi I have the following situation with a new application I will design for a distributor.

    They have sales people around the state and they need a way to enter orders from home.

    Also they need to enter orders in the main office.

    If the remote sales people enter orders in a Web based SQL server and the local people use a local Server SQL server.

    What is more efficient? To make the Web based server syncronize orders to the local based server? Tehy enter only around 120 order per day.

    or to eliminate the local server and only work with a web Server for both sides of the application? Is this going to be very slow for the local office?

    The application will be created in VB.NET with SQL Express 2005.

    Thanks in advance for your comments.

    Web solution is the best.

    you can also use SQLite.

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

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

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