I've been noticing a little lag in my application lately, it seems as
if 1 table in 1 database is getting slower to read from. Mind you,
that table is being accessed a LOT of times per second every hour of
every day, and then the "application" searches on this same table too.
In my sandbox, it is fast to search (as there is no other reads/queries
on that table), so i don't think it is disk i/o (but you never know
right?). I've also double checked all the indexing, to insure indexes
What I was wondering is, are the reads/queries simultaneous, or are they
sequential? would symlinking the file to another db make any difference
(or is that even possible)?
any insight would be appreciated, or even any ideas on what I may do to
increase the performance, or even how to measure where the issue could
be would help as well.