|
|
Posted by Steve on 10/26/05 20:18
> This works great, so I populated the DB with over 100,000 records and
> now page loads take 75-80 seconds for the total balance sheet page (I
> just loop through each user, and there are 100 users), and upwards of
> 10 seconds on a single user query.
Forget the SQL, the syntax is all over the place. Go back to the
original queries, but create indexes on columns `from_user` and
`to_user`.
---
Steve
Navigation:
[Reply to this message]
|