Jump to content
TNG Community
XerxX

SQL help would be appreciated

Recommended Posts

XerxX

Hi All,

Attached is a text file with the SQL code I use to produce the figures for the 52 places and 4 perishes pointed to at the map on this site index page

https://botebygden.se

(If you have trouble understanding what I do, because it's only in Swedish; just ask and I'll explain)

As you will notice, the map takes quite some time because of all the number collecting (it's really quick w/o the DB calls). And this is only a 690 persons DB... Every new figure is a DB call so it's 4 perishes x 3 events (below the map) and then 52 places x 4 events (list to the right of the map).

My hope is that the SQLs can be combined or something to increase the speed and to be able to handle a bigger register. But I don't know SQL so well so I'm looking for help.

 

Thank You In Advance, for any help or idea,

Erik

botebygdenSQL.txt

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×