Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 7 of 7 total |
Is C/S really needed on a webserver? |
Sat, Aug 4 2007 12:22 PM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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. Dave |
Tue, Aug 7 2007 4:33 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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. |
Wed, Aug 8 2007 3:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |