How to merge two databases by xpdo?

Are you selecting more than 30% of the rows in your table with the greater than query? If so, MySQL will apparently ignore the index and do a full table scan because it thinks it is faster. If you change the date to be more selective (smaller date range that excludes more records) I bet it will use the index.

Thanks, you are completely right. I just tried it for the column `ìd` and it is very fast when WHERE includes less than 30 %. Unfortunately it doesn´t work for a field which type is `date` like in our case (I tried: 2011-11-25 which should bring back less than 10 % of the rows).

Since we want the whole database (because we already deleted all events which took place in the past) is there any other tag to load the entire content of the database? We already tried this:



But this wasn´t any faster than the other call and I am in addition not sure if this is a correct syntax.

We got a big speed-boost by changing


into


Now the call takes far less than 1 second (comparing to >7 seconds by the getCollection-method). Is this maybe a hint for having an error in our schema? (we use the CreateXpdoClasses-Snippet for creating the schema.)

Does anybody has an idea what could be the problem in our setting?

I'm not sure:
Maybe it's because of creating all the Objects with getCollection.
Try to use getIterator instead of getCollection, the difference is described here:

http://rtfm.modx.com/display/xPDO20/Retrieving+Objects