Thanks for this great idea of looking at webform's submissions through mysql views.

I use the data module + drupal Views to display (parts of) the data to any user.
After about 2000 submissions the entire site is slowing down and particularly the page itself.
I wonder there is anything to do in order to improve selects of these mysql views.

Cheers !

Comments

cafuego’s picture

cafuego commented

The speed depends on a few things, most notably probably the schema of the underlying database tables and the mysql server configuration.

You can get an idea of what MySQL is doing by having Views generate your query and then running that from the mysql command line or using phpMyAdmin with the word 'EXPLAIN' in front.

Make sure that it uses as many indices as it can and don't hesitate to add an index to a table. If you're using a WHERE clause (filter in Views) on a text field, you may be in a world of pain regardless.