I just want to clear some of my confusions. So please guide be about this,
I had made an accounting software using vb6 + sql server 2000 , and currently its is working fine I am getting no problem. It contain may table like sales, purchases, stock etc.
Currently maximum entries is in sales database the rows are about more than 10,000 (ten thousand) in sales table. Other table has few thousand. Ok
Now , just I am suffering the net I got some material that when I reach about more records in a table let say 25000 (twenty five thousand ) or some what above the program may give a time out error while searching , updating or deleting record because the database will be larges, but we can add data properly,
So my question is , will this happens or no, and if this happens what to do to avoid it in the future and any other detail about this.