hilfe mein dupal-hoster will mich rausschmeissen!

hallo zusammen,

habe gerade folgende mail von siteground erhalten.

"We were monitoring the server that hosts your account and while reviewing the logs noticed that your website meinedomain.com was consuming a very high percentage of the server resources (processors' time and memory usage), thus endangering the overall performance of all the sites on the server. In order to keep the server at normal CPU load , we had to limit the shared server resources your account may use. Please note that this may result in occasional error messages, shown on your website.

We have conducted a detailed investigation of the reason for the high resource consumption and it turned out that your drupal script executes slow queries towards its database, which eventually hogs the server. The server tries to execute your slow queries while making other processes stay in the queue until some memory is freed. While they are waiting however, they stack up and further deteriorate the problem.

The reasons for such slow queries can be several:

1. Large database
2. Not well written scripts
3. Large number of internal links that query the database directly.

Upon further investigation, it turned out that the following queries in your account are slow and heavily consume server resources:

Executed 3 min ago for 118 sec on Database --> meinedomain_drpl1.
SELECT count( DISTINCT(node.nid)) FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN term_node term_node2 ON node.nid = term_node2.nid LEFT JOIN term_hierarchy term_hierarchy2 ON term_node2.tid = term_hierarchy2.tid LEFT JOIN term_node term_node3 ON node.nid = term_node3.nid LEFT JOIN term_hierarchy term_hierarchy3 ON term_node3.tid = term_hierarchy3.tid LEFT JOIN term_node term_node4 ON node.nid = term_node4.nid LEFT JOIN term_hierarchy term_hierarchy4 ON term_node4.tid = term_hierarchy4.tid LEFT JOIN term_node term_node5 ON node.nid = term_node5.nid LEFT JOIN term_hierarchy term_hierarchy5 ON term_node5.tid = term_hierarchy5.tid LEFT JOIN term_node term_node6 ON node.nid = term_node6.nid LEFT JOIN term_hierarchy term_hierarchy6 ON term_node6.tid = term_hierarchy6.tid LEFT JOIN term_node term_node7 ON node.nid = term_node7.nid LEFT JOIN term_hierarchy term_hierarchy7 ON term_node7.tid = term_hierarchy7.tid LEFT JOIN term_node term_node8 ON node.nid = term_node8.nid LEFT JOIN term_hierarchy term_hierarchy8 ON term_node8.tid = term_hierarchy8.tid LEFT JOIN term_node term_node9 ON node.nid = term_node9.nid LEFT JOIN term_hierarchy term_hierarchy9 ON term_node9.tid = term_hierarchy9.tid LEFT JOIN term_node term_node10 ON node.nid = term_node10.nid LEFT JOIN term_hierarchy term_hierarchy10 ON term_node10.tid = term_hierarchy10.tid LEFT JOIN term_node term_node11 ON node.nid = term_node11.nid LEFT JOIN term_hierarchy term_hierarchy11 ON term_node11.tid = term_hierarchy11.tid LEFT JOIN term_node term_node12 ON node.nid = term_node12.nid LEFT JOIN term_hierarchy term_hierarchy12 ON term_node12.tid = term_hierarchy12.tid LEFT JOIN term_node term_node13 ON node.nid = term_node13.nid LEFT JOIN term_hierarchy term_hierarchy13 ON term_node13.tid = term_hierarchy13.tid LEFT JOIN term_node term_node14 ON node.nid = term_node14.nid LEFT JOIN term_hierarchy term_hierarchy14 ON term_node14.tid = term_hierarchy14.tid LEFT JOIN term_node term_node15 ON node.nid = term_node15.nid LEFT JOIN term_hierarchy term_hierarchy15 ON term_node15.tid = term_hierarchy15.tid LEFT JOIN term_node term_node16 ON node.nid = term_node16.nid LEFT JOIN term_hierarchy term_hierarchy16 ON term_node16.tid = term_hierarchy16.tid LEFT JOIN term_node term_node17 ON node.nid = term_node17.nid LEFT JOIN term_hierarchy term_hierarchy17 ON term_node17.tid = term_hierarchy17.tid LEFT JOIN term_node term_node18 ON node.nid = term_node18.nid LEFT JOIN term_hierarchy term_hierarchy18 ON term_node18.tid = term_hierarchy18.tid LEFT JOIN term_node term_node19 ON node.nid = term_node19.nid LEFT JOIN term_hierarchy term_hierarchy19 ON term_node19.tid = term_hierarchy19.tid LEFT JOIN term_node term_node20 ON node.nid = term_node20.nid LEFT JOIN term_hierarchy term_hierarchy20 ON term_node20.tid = term_hierarchy20.tid LEFT JOIN term_node term_node21 ON node.nid = term_node21.nid LEFT JOIN term_hierarchy term_hierarchy21 ON term_node21.tid = term_hierarchy21.tid LEFT JOIN term_node term_node22 ON node.nid = term_node22.nid LEFT JOIN term_hierarchy term_hierarchy22 ON term_node22.tid = term_hierarchy22.tid LEFT JOIN term_node term_node23 ON node.nid = term_node23.nid LEFT JOIN term_hierarchy term_hierarchy23 ON term_node23.tid = term_hierarchy23.tid LEFT JOIN term_node term_node24 ON node.nid = term_node24.nid LEFT JOIN term_hierarchy term_hierarchy24 ON term_node24.tid = term_hierarchy24.tid LEFT JOIN term_node term_node25 ON node.nid = term_node25.nid LEFT JOIN term_hierarchy term_hierarchy25 ON term_node25.tid = term_hierarchy25.tid LEFT JOIN term_node term_node26 ON node.nid = term_node26.nid LEFT JOIN term_hierarchy term_hierarchy26 ON term_node26.tid = term_hierarchy26.tid LEFT JOIN term_node term_node27 ON node.nid = term_node27.nid LEFT JOIN term_hierarchy term_hierarchy27 ON term_node27.tid = term_hierarchy27.tid WHERE (term_node.tid = '9') AND (term_node2.tid = '10') AND (term_node3.tid = '11') AND (term_node4.tid = '12') AND (term_node5.tid = '13') AND (term_node6.tid = '14') AND (term_node7.tid = '15') AND (term_node8.tid = '41') AND (term_node9.tid = '43') AND (term_node10.tid = '45') AND (term_node11.tid = '44') AND (term_node12.tid = '42') AND (term_node13.tid = '46') AND (term_node14.tid = '6') AND (term_node15.tid = '8') AND (term_node16.tid = '47') AND (term_node17.tid = '48') AND (term_node18.tid = '49') AND (term_node19.tid = '39') AND (term_node20.tid = '7') AND (term_node21.tid = '50') AND (term_node22.tid = '4') AND (term_node23.tid = '2') AND (term_node24.tid = '5') AND (term_node25.tid = '33') AND (term_node26.tid = '34') AND (term_node27.tid = '36') AND (node.type IN ('stellen'

In order to have the limitations removed, please optimize your script. If this problem with your website is not resolved in 7 days we may need to SUSPEND YOUR ACCOUNT.

Sincerely,
"

leider hab ich null ahnung von datenbanken, was heisst "executes slow queries towards its database"?? wie kann ich das den beeinflussen?
ne grosse datenbank habe ich eigentlich auch (noch) nicht, die domain ist noch gar nicht öffentlich zugänglich und ich habe letztlich nur ein wenig mit meiner suchfunktion, bzw "views" rumgespielt, dort habe ich drei multiselectboxen zum auswählen und wenn ich in jeder selectbox mehrere items auswähle schafft drupal auch kein ergebnis mehr... ist das zuviel? wie kann man das optimieren, soll ja später auch im lastbetrieb mit vielen usern funktionieren?

danke
patcher