Database Via Unreliable Internet Slow. - General DRivers advice Methods.

I have to develop an Application that will need to store data into a Database MySQL prefered, but not a Must.

The problem/cuation I have is:

(1) Many USers
there will be many users: 2000 users not all logged in at once but; they will be logging events; Max 20 times a Day per User(this is worst case);

(2) The Connection
All Connections are done via the Internet

(3) The Connections Types
Some will be ADSL and some will be NORMAL internet DIAL-UPS.

Small Diagram
~~~~~~~~~~

User Application    -------(internet)----->SERVER (Event Monitor)
                           -------(internet)----->DB Server

The Event Monitor is on the same LAN as the DB Server.
User Application sends Events to the Event Server and the Event Server queries the DB Server.
Events are delivered via INDY/TCP.

*****************************

So I think there are two ways to handel this:

Solution 1
~~~~~~~
The User Appllication Writes data direct to the DB Server and sends some TCP data to the EVENT Server.

Solution 2
~~~~~~~
The User Apllication sends *ALL* data to the Event Server and the Event Server sends the database data to the DB.


*********************************
QUESTION 1:

My Question is This:
Which is BEST and Why. (there is little time left).

*********************************
QUESTION 2:
Database Connectors/Drivers

For Internet Delivery:

I am not to clear on the types of drivers you get; and I am not sure if MySQLDAC and others are capable of
delivering data on an unreliable Internet Connection.

**********************************
QUESTION 3
**********************************
Does one Get Asynchronouse and Synchronous Delivery Methods/Drivers ?

Or is it all the better to Write an Three Tier Model, I would hate to DO that Though, then I might as well use
a WEb server with Dot.Net to do the DElivery of data for me to the Database.


PLEASE Comment as MUCH as possible: I need REAL Experienced answers as to what works and what does not PLEASE.


THE above is URGENT; Please Only Answer if you can/have pratical advice/have done this before.

Any Recomendtaions welcome. Other Database all needs to be ROCK Solid and must be able to SCALE WELL!!! Since the LOAD
of the users will eventually even increase to 10 000 users.

But for starters 2000 uers. Maybe this needs to be split accross sever Databases?? not sure yet, cross that brdge whe n I get there.

cresttyAsked:
Who is Participating?
 
calinutzConnect With a Mentor Commented:
Try PostgreSQL,
I think it's the best for your purpose. Search on google for comparison between these two (PostgreSQL and MySQL)
PostgreSQL is free (for any kind of usage)
there are comercial (but not expensive) direct access components for posgres available at microolap.com:
http://www.microolap.com/products/connectivity/postgresdac/
(they also have DAC for mySQL too)
Anyway you MUST consider Direct Access components to avoid a translator between your delphi SQL and the SL of the Database server (which slows everything down and messes with your SQL syntax.

Look for documentations on PostgreSQL and it's functions and power. They will impress you. Most of the comparisons that were out there on the net between MySQL and Postgres are gone now ... probably because MySQL turned commercial and it was bad publicity


Regards
0
 
calinutzCommented:
0
 
calinutzCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.