After thouroughly reading trough many SQL optimisation sites I still fail to see what I can to to increase performance. To keep it short, my query joins 16 tables. When using explain, all the joins use foreign/primary keys so they are indexed. I double checked that since all the columns in the WHERE-clause of the explain have been index (again, as primary or foreign key).
Why is it that executing the query and fetching 100 records, takes 1600 ms? Truth is that 5,000 records take 2734 ms I don't understand why 100 recods take so long and 5,000 records are relative fast... Help? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
