data retreiving time?

[indian_indian]

hi... how much time takes for data retrival from big table(nearly 1,00,000 rows table)
i know about transcations system...its need for websites?,when it is needed

[Fumigator]

If your design is good and you've properly indexed your tables, access to the data takes just a few milliseconds.

When your tables get into the 10 million rows size, you want to start thinking about partitioning. But 100,000 rows is cake.

[guelphdad]

You need transactions when if an action doesn't complete then you can roll it back.
if you have a banking system for instance and you remove $100 from Tom's account and put it into Bob's account, you want to make sure both queries work or none work. You wrap them in a transaction and use rollback or commit as needed.