Mysql configuration

Is it possible to restrict maximum number of rows retreived for each user for a query in mysql  configuration ?
AXISHKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
Not sure what you are as,I got, how are you determining how many rows what is the basis on which you want to impose this restriction? What if the response to a query us 100 rows, but you set  the restriction at 50?

Yes, you would do it in the query using limit 1,50
Get the first 50.
51,100 will get the next 50.
Does the user create the query?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AXISHKAuthor Commented:
I mean a global configuration to retrieve all users not to return, say 10000 rows .... Is it possible ?
0
Pallavi GodseSr. Digital Marketing ExecutiveCommented:
Hi,

If you restrict a LIMIT 3000 in your query then it is possible to produce the result without generating the complete result set first.

For example, the following query:

SELECT * FROM table ORDER BY column LIMIT 3000
This query will need to scan the whole table unless there is an index on column.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Dave BaldwinFixer of ProblemsCommented:
Even if there is, it would not be a practical limit.  As Emma pointed out, some queries will scan the whole table anyway when there is not an index to speed it up.  If you limit the results to 1000 rows on a table that contains 10 million rows, some queries will still have to scan all 10 million rows.

Of course, if they are returning 10,000 rows to a web page, that's kind of stupid in the first place.
0
arnoldCommented:
What is your ultimate goal?

It is inevitable that your restriction will be too low as it would make no difference otherwise.

What is the context for your request?

If a request to produce items sold last week, and the restriction will lead to the response being useless as it lacks all the information because of your restriction.

you can limit the size of memory you allocate per query, but that could lead to complex queries failing to execute or if not, will take a long time to run and could be terminated for taking too long.

You seem to be looking to do something like restricting the distance a car can go at one time without the context what the distance of 90% of the trips. ......
0
AXISHKAuthor Commented:
Tks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.