MySQL ODBC Connector - Problem with Very Big Database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem with Very Big Database

Nick name

2005-10-27, 9:23 am

Hi,

I am creating a Database Architecture and there is a volume problem
with MySQL.

My tables are quite simple. Problem is they will record million of
lines.
Within 10 seconds, MySQL could receive 1.000 querries to insert raws in
the same table.

After 30 days, a table could be a 30.000.000 lines table.

I see several problems :
1. multi-querries at the same time
2. very high volume of database
3. recognition scripts and browse within results will be too long.

I think of having researched and developped multi-threading querries to
MySQL and back-tables that receive cut/paste from the main table.

I hope you had the chance to work with important volume, in order for
me to listen and work on the development of advised solutions.

I thank you for Your response,

Sophie
Ref : EC

Sponsored Links