Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: performance

  1. #1
    Regular Coder
    Join Date
    Dec 2010
    Thanked 11 Times in 11 Posts

    Question performance


    I've just uploaded some great big old table of all UK postcodes to my database. 1.6 million records of Postcode, Latitude, and Longitude. As I imagined, when retrieving this data via a SELECT query, and inserting the marker on a Google Map according to the Lat,Long found - there is some degree of loading. It's not too much, but about 3 seconds worth.

    Is there any way of improving the speed of this? Does it depend on the server you are using etc, or other factors?

    Advice would be great.

    note. UK - US phrase book. Postcode = ZIP Code

  • #2


    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts