Solved

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

Posted on 2006-10-25
5
136 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
creating threads in delphi 1 163
how can i search if string exist in array ? 3 69
Get weeknumber and year from date 4 29
Using MMsystem To change audio input 1 18
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…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 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