On Sat, Sep 5, 2009 at 5:10 AM, mos <mo...@fastmail.fm> wrote: > 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 > > -- >
Thank you for the feedback and input from all friends. Currently I have yet enter the design phase, just survey phase to get the information about the data which will migrate from the legacy application. Fyi, the input data which will migrate to MySQL is txt and not normal for Relational Database. Based on existing feedbacks, I conclude that this project makes sense and can be continued. Perhaps with a note of the problem in vailure single point because there is only 1 server. Furthermore if there is progress again, I'll try sharing. Thank you very much -- Muhammad Subair
