On Sat, Nov 03, 2001 at 12:07:03AM +, Manjeet Singh wrote:
Hi Group,
I am new to mysql, and would like you all to give some time in
resolving my trouble. I am stuck up with a problem of designing
stores database for a big company.The company is located in
different places and wants web-based insertion, retrival and
maintaining of data and records in the database.
Okay...
I am worried of the performance and speed of quering the database
and getting displayed on the browser, as they have around 25 million
records in the database.
25 million records isn't a lot, given modern hardware.
I need to know:
1) What is the maximum storage capacity of MySQL,
It's really, really big. I don't remember the exact number anymore,
but there has been at least once instance of a database with over 2
billion rows in it.
2) How will be the performance for this type of huge
database, where web-based frontend is used and what can be
done so has to increase the performance.
Make sure you give MySQL sufficient memory. Make sure you data is
properly indexed.
3) How to speed-up the querying time, as the queryed
results are manipluated through scripts and displayed on
web browser.
Same as above.
4) How can it be tuned for a better performance.
Again, same as above.
Have a read thru this:
http://www.linux-mag.com/2001-06/mysql_01.html
to start with. And watch for part #2 in the December issue. :-)
As, i am still in the planning stage with the details of my client
as above, i have to decide on with wich database i should proceed.
I would also want to know will MySQL is capable of
withstanding the load:
Yes.
1) As so many users from different locations will be
querying and getting results on web.
How many users at once?
2) Even they are users who will be adding data to the
database.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 60 days, processed 1,316,159,175 queries (253/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php