Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2006-10-25
5
Medium Priority
?
142 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
3 Comments
 
LVL 11

Accepted Solution

by:
calinutz earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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 Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses
Course of the Month13 days, 15 hours left to enroll

581 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