Re: MySQL Performance - multiple concurrent processes

[Andrew Carlson]

- I will try the query cache - didn't know it would affect it so much

- I put it there, because in the future when I get to it, I will be storing more inofrmation there that needs to be checked when backing up the file. The objects table does not include the path information, and I guess I could get those 3 fields from there, but since I split out the files table (and the intention right now is to have one files table per client), I left those fields in there. I will think on if I can eliminate those or not - this project is in the infancy stage.

- I will query the files table, but I am not there yet, so I haven't decided on indexes.

- I did not know that about the varchar. The maximum filename size in most filesystems is 256, but if that makes it a poor performer, I will have to see how many of the filenames really reach 256

Thanks for the input.