CODEWITHSUNDEEP
mysql
Dharmalingam Arumugam
Dharmalingam Arumugam

Reputation: 407

Does Mysql Select Query can fetch 500,000 record?

I am using MYSQL SELECT query for fetching records. If i have 500,000 of user's record in my users table. does SELECT query support?

Upvotes: 0

Views: 231

Answers (2)

user319198
user319198

Reputation:

Yes you can. even you can get more then 500000 rows. There is no such limit by mysql.

But you should control no of records by programming language using pagination and using limit clause with select. Fetching such large no of records at once will degrade performance.

Upvotes: 0

CanSpice
CanSpice

Reputation: 35788

Yes. Running a SELECT over 500k records is doable.

Upvotes: 2

Related Questions