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(*))