It seems that dmWebskinAncestor table just fills up with records. Are records that are no longer needed ever deleted? I have a table that has over 280k rows in it, some that date back to May of 2009.
For certain setups the checkAncestorExists method is run many many times per request and therefore there are many hits to the database. Over time there are more and more records in this table, so each time the query is run many records are returned. For example: I am looking at a request right now that returned over 150k rows from the database. The 30 slowest queries were all requests to the dmWebskinAncestor table and they returned over 3000 records on each query. Can this table safely be truncated periodically? Does FarCry core manage it itself? It seems to me that the table would query much faster if there were fewer rows. Also perhaps the methods in dmWebskinAncestor should be refactored to return only a single row. The checkAncestorExists, for example, only needs one row to return true. Why return all the rows if they aren't needed? -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
