ChristineH is on the right lines IMO. To add to what she's said, try running your SQL with EXPLAIN in front of it to see what is returned. If you see any full table scans and/or large numbers of rows, you'll need to look at rewriting your view or possibly…