Hi,
If you have a larger number of products with lenghty contents, I would recommend using the Index Table engine. The tutorial in the link will explain everything about the configuration.
It should greatly increase the performance, if the issue was related to the number of items.