Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorviane
    • CommentTimeFeb 13th 2007
     
    Hi guys,

    i want to create a site which can record simple inputted data to a database. I expect there maybeover a million records in the database.

    Can you advise on the easiest/best solution for this please.
    • CommentAuthorprogrammer
    • CommentTimeFeb 13th 2007
     
    MySQL should be good enough to handle 1million records. If you have enough budget, you may consider Oracle or MS SQL as well.
    • CommentAuthorjustnajm
    • CommentTimeMar 26th 2007
     
    MS SQL is very good RDBMS and it provided more optimized ways to manages such large databases, It has buitin Query Optimizer System in it.

    I advice you the MS SQL if you want performance.

    On the other hand MySQL is also not bad !