> Are the master, temp, and user DB's located on separate physical disks on separate physical controllers. I have a transaction intensive DB that had substantial performance issues until I added a controller and disks and moved the user databases to it. What is the physical layout of the MISESSATA2003 server?
It's a single server with 4 cores and a RAID 1 array. Everything is on the same drive. I think if we just optimized the worst queries, it would make a big difference. I'm not a DBA.
> The first method is basically what the proc does - measuring co-relatedness.
Yes but can we measure that by the number of tags that documents have in common? Right now it just looks for any matching tag.
Yes, I think this is what we need to do better.
> Another way is defining tag tuples for each combination of tags on a document and then measuring co-relatedness of the permutations of tag tuples (so basically a multiple level co-relatedness value).
Can this be done on-demand, or does it require a scheduled task?
>What metadata is available though on documents (or items - whatever they need to be called) and what tables are they stored in?
Check out [dbo].[GetContentbyGUID]
We have all kinds of different documents - this is where I try to abstract out the schema.
Check out the "related stories" on this page" http://mises.org/story/3766