Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design in regards to online store
Message
From
09/04/2010 02:29:58
 
 
To
09/04/2010 02:07:26
General information
Forum:
ASP.NET
Category:
Web Services
Environment versions
Environment:
VB 9.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01459412
Message ID:
01459413
Views:
49
>So far, online stores I have set up were having the database on the server. I mean, the main database was on the server. So, basically, it was maintained thru the Web by the administrative interface.
>
>Now, I have a situation where the client as its POS system in the store, and that is the main database. So, basically, we have to duplicate that across the wire to the server. So, I will have a module installed locally which will synchronize the Web server every 15 minutes. This is good for up to a certain number of items. If the client has 10,000 items to sale, then, we would have to think about an alternative as synchronizing that across the wire, with the related images, would take a lot of time.
>
>So, the question is, when we have that much items, would it better to consider moving the main database to the Web server instead and having the POS application in the store reading the data from it?

If you mean, the sole database would be on the Web server, with no local copy in a store, that probably isn't acceptable. The purpose of a POS is to reliably and quickly process sales transactions. Internet connections go down too often. Also, latency could be a significant problem.

>If this is not possible, what are the alternatives?

Some databases support replication e.g. SQL Server: http://msdn.microsoft.com/en-us/library/ms151198.aspx
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform