Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design in regards to online store
Message
From
09/04/2010 02:07:26
 
 
To
All
General information
Forum:
ASP.NET
Category:
Web Services
Title:
Design in regards to online store
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:
01459412
Views:
121
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 this is not possible, what are the alternatives?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform