AXISHK
asked on
Mysql configuration
Is it possible to restrict maximum number of rows retreived for each user for a query in mysql configuration ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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. ......
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. ......
ASKER
Tks
ASKER