i uderstand why the count(*) can be very slow because it's must read all the data to know how many reccord ... but is their any way to give a limit to the count(*) ? for exemple if more than 10000 row read then stop the count(*) and return 10000
something like select min(10000, count(*))
