Set Limit On cursor Object before execute query in python

Question

I have one query which I ran on mysql, mssql or oracle like

select * from user

that query give me 0.5 million records/rows. I want to get only 10 rows. Below is python code :

 cursor.execute(query)
 columns = cursor.description
 rows = cursor.fetchall()

I tried using cursor.fetchmany(10) and that condition is giving me 10 row but it takes a lot of time. I want to set a limit before executing the query so that it will be not take much time and also got fast execution. Please give me any solution in python. Please help me...

that query like a example any one random to pass query. but i need to set limit on my side. because i don't known how much data in this query. but i need only 10 rows. — Devanshu Sharma
– Devanshu Sharma, Commented Nov 30, 2018 at 10:01
what I am saying you can add/bind rownum to the query you are executing, otherwise you have to wait for query to return all the records then only you can filter it. — Sach
– Sach, Commented Nov 30, 2018 at 10:09
if query have nested or multiple joins with multiple table. If cursor object have that property then please tell me — Devanshu Sharma
– Devanshu Sharma, Commented Nov 30, 2018 at 10:12
can you please try setting this to 10 and then iterate over cursor intead of using fetchall, also break in first loop. initd.org/psycopg/docs/cursor.html#cursor.itersize — Sach
– Sach, Commented Nov 30, 2018 at 10:22

methane · Accepted Answer · 2018-12-02 04:30:26Z

1

When you only need 10 rows, use select * from user LIMIT 10.

answered Dec 2, 2018 at 4:30

methane

4893 gold badges5 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Devanshu Sharma Over a year ago

I need to reduce execution time. Like java have that type of property using prepared statement. You can set statement.setFetchSize(500);

methane Over a year ago

You can user SSCursor, but configuring fetch size doesn't reduce execution time on MySQL server side. Adding LIMIT clause is much better than limit fetch size on client side.

Collectives™ on Stack Overflow

Set Limit On cursor Object before execute query in python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related