This might sound basic and confusing - here goes, is there a maximum number of records that mysql will return to a page with out significantly slowing download time. I know it depends on the structure of the rest of the page etc.
My problem is that I have a page that potentially pulls 2500 records (id_num, county, town,postcode) from a table. This is used in a double dynamic select box. I'm having to pull this off again to populate a second series of selects - ie first select is the TO destination, second select is FROM destination. With the code I've got I don't seem to be able to use the same record set twice
Ideally i want this all one one page, I could split it across several pages but only if I have to.
Some one will no doubt look at this and say - "hes avin' a laugh"
Any help would be much appreciated.
SMIFFY