Database Experts Opinions Wanted
I'm running a server that handles logging and reporting. It's pretty processor intensive. I have a list of numbers that i'd like to update the server with, approximately 100,000-1,000,000 numbers that have a URL attached to them in a seperate field. I'm being told that it is taking too long for the database to be query'ed and spit out an answer...what can I implement to make the query go faster?
So far, my thoughts are:
#1) Remove the keyword part of the schematics to a seperate server and run the querys there and report back the answer.
#2) Update and improve the technical aspects of the server (more RAM, processors, etc)
Anything else? Any help is very welcomed.
