At 11:48 AM 9/4/2009, you wrote:
One of my potential clients want to migrate their application to web based
(PHP & MySQL), estimates of the data size is 24GB and growth per month is
20MB of data. Unfortunately, they could only use 1 sever machine with 4GB
RAM.
The application used in intranet, just running simple transactions and the
number of users concurent is under 10.
I need information and suggestion about this condition, whether the effort
spent on implementation and future maintenance is not too large for use
MySQL with this condition?
*btw sorry for my English*
Thanks you very much,
--
Muhammad Subair
Muhammad,
It will depend on your queries and how efficiently you write them. A
poorly constructed query on a 24MB table will perform worse than an
optimized query on a 24GB table. If you can show us your table structure
and query example, (are you joining tables?), then we can guestimate better.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
