Re: Basic application design

April 1, 2008

Thank you very much for your comments.

Like I mentioned earlier, the database will be used and updated
simultaneously by users in all four countries. Replication would not be
preferred due to internet related issues.

So please bear with me if I ask the same questions again, keeping in mind
that in one country, approximately 50 users will be online.

1. Database is in one country where the internet is excellent. All the other
three countries have a local application developed in VB Net using this
database.

2. Go for a complete ASP Net based solution.

Q1. Which solution I should go for ?
Q2. In terms of performance and speed, which option would be better keeping
in mind that there will be 50 users in one country and the internet
bandwidth would be approximately 512MB (At the moment a higher bandwidth is
difficult and costly)
Q3. If we go for an ASP net based solution, then the server hosting the
applications and data has to be a very heavy server keeping in mind again
that approximately 200 users would be online at a certain point of time.
Q4. 50 users logged on to an ASP Net based application using the browser
Versus 50 users logged using a local application only using the database
from a remote server, which would be faster.

Thank you in advance.

Mike TI


"Spam Catcher" <spamhoneypot@xxxxxxxxxx> wrote in message
news:Xns9A72776B313D5usenethoneypotrogers@xxxxxxxxxxxx
"Mike TI" <tanveer@xxxxxxxxxxxxxx> wrote in
news:#mYvG1ykIHA.2396@xxxxxxxxxxxxxxxxxxxx:

Questions:
1. Is the above strategy good and workable looking into the number of
users who would be logged on at the same time and the fact that
internet speed in three countries is average.
2. Should the whole setup be in ASP. Please consider here then that
approximately 50 users will be connecting to the application through
the web browser high band width is not available in these three
countries and also very expensive.

A simple way to distribute an application is to implement a web service
interface - that way you don't need to expose the SQL database to the
internet and you can enforce business rules.

Another solution is to deploy local instances of SQL Server and setup
replication to a central database. This allows international users to
have their own local data cache and thus should increase performance.
This solution obviously costs more money and is more complex to setup -
but might be a consideration if Internet is flakey in the foreign
country. You should still front the database with a web service to
prevent direct access even though the data maybe local.


Hard to say what is best ... since I'm not sure what your skillset,
budget, and requirements truly are :-)


--
spamhoneypot@xxxxxxxxxx (Do not e-mail)


.

Relevant Pages

  • Re: WHY
    ... as easily as you can put it in a spreadsheet? ... Rates are defined BETWEEN two countries. ... > countries to determine the respective exchange rate basis (and I hope ... > And this is something you can't directly translate to a database. ...
    (microsoft.public.excel)
  • Re: Working with Timezones and DST
    ... time it is in other countries. ... have the server work this out, without having to update a database ... or do I need to connect to a time server? ... PHP 5.1 introduced improved timezone handling into the core of PHP itself, ...
    (comp.lang.php)
  • Re: Keyboard Layouts
    ... I have a terminal server which is being used internationally. ... people in other countries are using a database that is used to record information. ... Make sure you download our free guide about Terminal Services. ...
    (microsoft.public.windows.terminal_services)
  • Re: How many names and addresses can you have for ID card
    ... But a German database, or an American one, would be orders ... but not about other countries. ... you don't think a German or American-designed database would be ... If you associate with the wise, ...
    (uk.legal)
  • Re: How can I organize my database?
    ... in a relational database, you don't want to do this. ... > chance to put more countries and more regions for each agency at the same ...
    (microsoft.public.access.tablesdbdesign)
Loading