how many record mysql can store? if my average record add in is 1500, should i split the table into 2? Thanks.
If you plan to store same sort of table structure then I suggest you "NO"
You can store any no of data in database subject to disk availability of disk space and databse size
I frequently store around 250,000 records in one table in MySQL, and another couple of hundred thousand across three others. I don't hink 1,500 is going to be a problem :-)
