Solved

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

Posted on 2006-10-25
5
133 Views
Last Modified: 2012-05-05
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.

0
Comment
Question by:crestty
  • 3
5 Comments
 
LVL 11

Accepted Solution

by:
calinutz earned 500 total points
ID: 17806602
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
 
LVL 11

Expert Comment

by:calinutz
ID: 17806626
0
 
LVL 11

Expert Comment

by:calinutz
ID: 17806650
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question