Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2006-10-25
5
Medium Priority
?
140 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 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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

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…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

604 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