On Friday 04 September 2009 08:15:35 pm muhammad subair wrote: > 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 > Perhaps its worth looking at a master-slave relationship between 2 servers if you are concerned about a single point of failure.
Colin -- There is a 20% chance of tomorrow. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org