I have a client who wants me to take on a project wherein they have, on
another table in another DB, about 1.2 million records. I am going to have
to consider, in this project, a record length of about 200 bytes, and am
wondering if MYSQL (5.x, on a first-rate Windows server) can handle such
size. Does anyone have experience with something that large? Thanks, Ike 2 1589
There's no doubt that MySQL itself has no problem with this amount of data.
Of course, whether it works (fast) depends on a good database design (e.g.
correct indexing) and that the hardware meets the requirements.
There are in fact people who complain that MySQL cannot handle a large
amount of data. But the true reason is almost always that something's wrong
with design, hardware etc.
The performence would probably be better on a Linux server, as MySQL is
better optimized for Linux than for Windows. However, if hardware and
database design are correct, it should work on Windows, too.
Markus
It should be no problem at all but, as always, every problem is so
specific we'd need more details about what you'll do with this data:
mostly updates, inserts, selects, etc? How many concurrent users, etc?
I used to work at a place where we had a few tables in the 10+ million
rows with rows averaging 175 bytes if I recall correctly. Most of the
queries were selects.
I am now working on a table with 2.2 million rows of size 204 bytes and
mostly doing selects against it. Other tables are insert-select-delete
(barely serving as messaging queues) which are pruned every minute.
Every project is specific and, the easy answer is you can do anything
as long as you have a good design, proper indexing and good hardware.
More details about what you want to do would probably give us a chance
to better estimate your possible bottlenecks/problems.
You usually have problems when you have queries not based on the PK
(thus something doing table scans, file sorts, group by, etc), lots of
joins (especially outer joins) or have lock contention because of many
concurrent users... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Andrea Griffini |
last post by:
I did it.
I proposed python as the main language for our next CAD/CAM
software because I think that it has all the potential needed
for it. I'm not sure yet if the decision will get through, but...
|
by: 6thirty |
last post by:
Hi,
I've created a stocktaking database using Access XP. This is indexed by two
fields - part number and shelf location.
I am currently inputting all the data via a form. When I have entered a...
|
by: Salad |
last post by:
Every now and then I see ads that state something like "Experience with
Large Databases ...multi-gig...blah-de-blah" And I have to laugh.
What's the difference between a large or small database? ...
|
by: darrel |
last post by:
I'm trying to whip up a fancy repeater control that will put records into a
two-column table for me.
This is how I envision it working:
itemtemplate
if record count = odd then write out the...
|
by: Louis LeBlanc |
last post by:
Hey folks. I'm new to the list, and not quite what you'd call a DB
Guru, so please be patient with me. I'm afraid the lead up here is a
bit verbose . . .
I am working on an application that...
|
by: Peter W Johnson |
last post by:
Hi guys,
I have a problem with a datagrid record count. Here is the code:-
<snip>
Public Class frmMerchantDeposit
Inherits System.Windows.Forms.Form
Dim myconnection As New...
|
by: elena |
last post by:
Hi, All
I have flat text file with fixed record lenght w/o record delimiter, i need
read this file and populate Access Database table, how can i achive this?
The Record count is 1465321 records: I...
|
by: tekctrl |
last post by:
Anyone:
I have a simple MSAccess DB which was created from an old ASCII flatfile.
It works fine except for something that just started happening. I'll enter
info in a record, save the record,...
|
by: Terry Carroll |
last post by:
I am trying to do something with a very large tarfile from within
Python, and am running into memory constraints. The tarfile in
question is a 4-gigabyte datafile from freedb.org,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |