Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Is C/S really needed on a webserver?
Sat, Aug 4 2007 12:22 PMPermanent Link

Dave Harrison
I'm planning on putting a website together with DBISAM 4.25 as the
database. It will have Fulltext searching and some ranges. I may be able
to avoid using queries altogether.

Is there any advantage of using C/S instead of the Multi-User version
if the database is on the same machine as the webserver?

TIA
Dave
Mon, Aug 6 2007 6:13 AMPermanent Link

"Jose Eduardo Helminsky"
Dave

No.

You should not use C/S in this case (database is on the same machine as the
webserver) because it will use more resources than direct access. IOW, it
will be slower than direct access.

Eduardo

Mon, Aug 6 2007 4:15 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< Is there any advantage of using C/S instead of the Multi-User version if
the database is on the same machine as the webserver? >>

Eduardo is correct.   Using the direct local access is the best bet in such
a case.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Aug 7 2007 2:18 AMPermanent Link

Dave Harrison
Tim Young [Elevate Software] wrote:
> Dave,
>
> << Is there any advantage of using C/S instead of the Multi-User version if
> the database is on the same machine as the webserver? >>
>
> Eduardo is correct.   Using the direct local access is the best bet in such
> a case.
>

Hi TIm,
    So there is no advantage to using C/S for a multi-threaded app
(like a webserver) if the database is on the same machine as the app? I
guess once I move the database to another machine to offload the strain
of the webserver, it would be time to switch to C/S. But then moving to
C/S will slow down the db (it's now over a network), but this will
increase the speed of the webserver. So it is something like balancing
my Yin and Yang. http://en.wikipedia.org/wiki/Yin_and_yang

Speed up one part, but slow down another. It's like a pie chart and if
you make one piece larger, the other piece shrinks.

I can't see moving to C/S unless I have more than 1 webserver accessing
a central database. Even then if it were a busy site, I'd probably
prefer to use local databases on each webserver so there is redundancy
and replicate them from a central database. That's how MySQL works for
large webs sites. Food for thought. Smile

Dave
Tue, Aug 7 2007 4:33 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< So there is no advantage to using C/S for a multi-threaded app (like a
webserver) if the database is on the same machine as the app? >>

Not in terms of performance, no.  You do gain the C/S features that aren't
in the local sessions, such as logical database names, scheduled events,
server-side procedures, etc.

<< I guess once I move the database to another machine to offload the strain
if the webserver, it would be time to switch to C/S. But then moving to C/S
will slow down the db (it's now over a network), but this will increase the
speed of the webserver. >>

What do you mean by "it's now over a network" ?  Do you mean that you're
using local sessions but accessing the database on another machine besides
the web server machine (file-sharing) ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Aug 7 2007 5:26 PMPermanent Link

Dave Harrison
Tim Young [Elevate Software] wrote:

> Dave,
>
> << So there is no advantage to using C/S for a multi-threaded app (like a
> webserver) if the database is on the same machine as the app? >>
>
> Not in terms of performance, no.  You do gain the C/S features that aren't
> in the local sessions, such as logical database names, scheduled events,
> server-side procedures, etc.
>
> << I guess once I move the database to another machine to offload the strain
> if the webserver, it would be time to switch to C/S. But then moving to C/S
> will slow down the db (it's now over a network), but this will increase the
> speed of the webserver. >>
>
> What do you mean by "it's now over a network" ?  Do you mean that you're
> using local sessions but accessing the database on another machine besides
> the web server machine (file-sharing) ?
>

No. I meant when I upgrade to C/S, I'll move the FileSharing database
(which is on the webserver) over to it's own machine (convert it to C/S)
so it gives the webserver more CPU because it's no longer doing the
database work. So some of the speed that the webserver gains, will be
lost with slower network access to the database.

Dave
(Sorry for the confusion. English is my first language.Smiley
Wed, Aug 8 2007 3:15 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< No. I meant when I upgrade to C/S, I'll move the FileSharing database
(which is on the webserver) over to it's own machine (convert it to C/S) so
it gives the webserver more CPU because it's no longer doing the database
work. So some of the speed that the webserver gains, will be lost with
slower network access to the database.

Ahh, yes, you are 100% correct.  However, there are ways to mitigate the
biggest issues with "chattiness" and network round-trip times by using
server-side procedures.   They will give you local performance with remote
sessions.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image