[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Improve speed on retrieving data
On Fri, 11 Jan 2002, Dan Browning wrote:
> However, if you are saying that the query is slow in IC but fast when
> executed directly in mysql, maybe you should try today's CVS as it
> removes the need for specifying rf="" so that IC doesn't have to do a
> select * (which may be what is happening to cause the slowdown in your
> query).
The commit I made today actually doesn't change that, Dan. But I don't
believe IC is always selecting * to get the field names. It should check
only at daemon startup time, anyway. To be certain, see the full SQL query
log from your database (easy to do with MySQL or PostgreSQL) to see what
queries IC is doing. That should shed some light on how that works.
Jon