For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > October 2007 > Re: [PHP-DB] Remote DB Connection: Pros and Cons?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [PHP-DB] Remote DB Connection: Pros and Cons?
peter lovatt

2007-10-11, 10:00 pm

Hi

You would be better off with the database server and php on the same server
- both sites.

You will find there is significant lag if there is a poor
connection between the web and database server, but if you are just
accessing web pages
and updating data, even with large pages there is not much delay.

You could always try both permutations and see, but that has been my
experience.

Peter



On 12/10/2007, Chris <dmagick@gmail.com> wrote:
>
> Tony Grimes wrote:
> database
> sister
> website
> site.
> there
>
> Do the website and admin area reference the same database tables?
>
> If they don't, split the database up and keep the website db on the
> website server and the other internally.
>
> If they do, which one is the 'primary' set? ie which one gets updated?
>
> You could use replication to keep them in sync (http://www.slony.info/
> for example).
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com