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
>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,
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.