owncloud/core — pull request #271 by DeepDiver1975 (2012-11-05 21:45:54+00:00)
Title: fixes #329: query the database in chunks of 200

My setup: apache + sqlite + all on localhost:

current implementation: 0.1331 sec.
proposal within #329: 0.5020 sec
chunked in packs of 999: 0.3075 sec
chunked in packs of 200: 0.2089 sec

chunk size of 200 gave the best results with my setup

A LIKE based query will not work due to the special case of 'Shared' - afaik