Are you running your sites on the same server? If yes use only one database for all of them.
Unless he's installed the latest of either SSvX* or QFCP**, I'm guessing his server isn't installed at multiple sites.
* [SSvX] Schrodinger's Server vX
** [QFCP] Quantum Flux Computing Platform
He could just have all the 'sites' use the same database if they were websites, he meant sites as in on-site, e.g. physical locations.
I have to agree that you're basically stuck with either replication, or the frequent synchronization you're doing now - depending on whether or not the servers can always be on. Is it possible to have a delay on the updating of information - to have a master server for the writes, and local slave servers at each site for just reads - or are writes too common a change?
- Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php