Hi there. I currently have an Online Computer Shop. The Database is quite large (Has been up for about 7 years). Now this is an online shop, but when someone comes to the physical store we use it as well, for invoicing etc. We also use OSCommerce for all the stock we receive etc. I was hoping to have one version online, and one running on a server on LAN. This way if we're doing stock or someone order in store it's on LAN, and online can just go off US server. US Server very slow for us down here in New Zealand and will decrease checkout times in shop. Is there a way for me to do a incremental update say every hour or two. (All it means is customers invoices won't show up on there account for a few hour after, no big deal). Let me know if this is possible. Appreciate the help. Cheers. -Antony
I would go for a replication setup between the 2 servers. You can have the web server replicate to the local server. You select and search the local server, and you update the main server. When you update the master server, it propagates to your local server. This way, your data all stays current. Unlike querying, a single replication command would be nearly instantaneous even over a long distance. If you try to do something every hour, it will e difficult to prevent collisions and complete loss of integrity in your 2 databases. This is why I would go for the replication.