My indexfile has two database queries but tables are getting bigger everyday and with up to 12000 uniques a day some optimization might be in it's place. Tables are indexed.
My question is if it would be faster to have two include files instead of two database queries?
Or even skip the includes and have a script to build the indexfile every hour?
What would happen if one request the file in the moment it's being written by the script?
Or can the file be cached?