## Featured Replies in this Discussion

- by pritaeas

For a moment I thought I was being REALLY stupid :D

Goedendag Pritaeious, but that only returns 1000 results even if there are 25000 matches. I want to make an initial query that will tell me the exact amount of matches and no data, and then a second query collecting the data with a limit of 1000, or one that does both if it is possible.

Thanks for your speedy consideration :D

Ah, okay. Just use the original query and select only `COUNT(*) AS resultcount`

. That way the server does the counting, but only one record gets transferred to your script.

```
select count(*) as resultcount
from SW
where (acos(cos(51.496502411798 * (PI()/180)) *cos(-0.13982862499836 * (PI()/180)) *cos(lat * (PI()/180)) *cos(lng * (PI()/180))+cos(51.496502411798 * (PI()/180)) *sin(-0.13982862499836 * (PI()/180)) *cos(lat * (PI()/180)) *sin(lng * (PI()/180))+sin(51.496502411798 * (PI()/180)) *sin(lat * (PI()/180))) * 3959) < 1
```

If I were you I'd put them in two stored procedures. Keeps your code nice and readable.

Earn rewards points for helping others. Gain kudos. Cash out. Get better answers yourself.

It's as simple as contributing editorial or replying to discussions labeled OP Sponsor or OP Kudos