Re: To CS or not to CS?

From: Paul Pedersen (no-reply_at_swen.com)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 15:55:57 -0800

> An INSERT definitely shouldn't take that long.

Sorry, I was misleading there. It was a simple insert, plus some other
processing that should also be quick.

> Something is wrong. Is your
> network strained for bandwidth?

Could be.

> And, for what it's worth, there are many reasons to go to a C/S
> architecture
> but performance is NEVER on the list.

That surprises me. I had thought that it WAS a reason, particularly with
large data sets and large numbers of users.

Can you explain?

"Dan Freeman" <spam@microsoft.com> wrote in message
news:unNwd5mLFHA.3336@TK2MSFTNGP10.phx.gbl...
> An INSERT definitely shouldn't take that long. Something is wrong. Is your
> network strained for bandwidth?
>
> And, for what it's worth, there are many reasons to go to a C/S
> architecture
> but performance is NEVER on the list.
>
> Dan
>
> Paul Pedersen wrote:
>> And what about my questions? Do users really have to read and write
>> multi-megabytes to make a small change?
>>
>> Some of these changes are rapid-fire, too - bar code scanning. Trying
>> to do one every second or two, but simple inserts are taking up to 10
>> seconds each.
>>
>>
>>
>>
>>
>> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
>> news:%23FYq5MmLFHA.2988@TK2MSFTNGP14.phx.gbl...
>>> Not my experience. We usually have 250-300 users and no complaints
>>> on speed of views.
>>>
>>> --
>>> Fred
>>> Microsoft Visual FoxPro MVP
>>>
>>>
>>> "Paul Pedersen" <no-reply@swen.com> wrote in message
>>> news:uVc5ACmLFHA.3960@TK2MSFTNGP12.phx.gbl...
>>>> I have 3 - 10 users making edits and adding records to tables of 3
>>>> - 20 MB in size, usually using views, but sometimes directly. Each
>>>> change is no more than a handful of fields in one or two records,
>>>> but as the tables grow, I'm starting to get complaints about
>>>> slowness.
>>>>
>>>> In a file server system like this, does each user have to read and
>>>> write an entire multi-megabyte table every time they make a small
>>>> change? Or does the file server and/or network do some buffering
>>>> and change management for me?
>>>>
>>>> In general, when is it time to consider switching to client-server?
>
>

Relevant Pages

  • Re: Duplication in events mechanisms in java?
    ... > No, they are not ok for non trivial event systems, because: ... architecture that is going to be based on them (or on the other kind ... So that means that regarding the main reason: Main reason: Observable ... by building my own infrastracture upon the observer/observabale ... ...
    (comp.lang.java.programmer)
  • Re: Root Terminal Security Question
    ... Perhaps the reason you don't see a lot of ... everything from Fidonet to Usenet. ... And the amount of bandwidth saved by limiting tags to four lines pales ... If I spent all four of my taglines ...
    (comp.security.misc)
  • Re: Root Terminal Security Question
    ... Perhaps the reason you don't see a lot of ... everything from Fidonet to Usenet. ... And the amount of bandwidth saved by limiting tags to four lines pales ... If I spent all four of my taglines ...
    (comp.os.linux.security)
  • Re: Space travel by humans is not possible now
    ... Trim them to conserve bandwidth. ... :> The whole 'bandwidth' whine was a strawman argument even back in the ... The real reason is that it's generally just unmannerly to not bother ...
    (sci.space.policy)
  • Re: Difference Between .com & .local
    ... Rick K typed: ... So it is part of a typical AD Architecture?? ... The reason I ask is I inherited a 2003SBS network that I performed a ...
    (microsoft.public.windows.server.networking)