[Rt-devel] Optimizing _BuildItemMap / ItemsArrayRef in
rt at hsufarm.com
Tue Apr 26 13:43:51 EDT 2005
I was wondering how one would go about optimizing _BuildItemMap found in
One thing that it does on an unrealistic test database that has 10,000
results for a search query is that it loads each row into memory and sorts
them. Then _BuildItemMap only keeps the ticket id's. This isn't bad, but
for 10,000 tickets, with about 4k/row, that's 40MB of information that
needs to be transferred from the database.
Can _BuildItemMap be written such that it doesn't use ItemsArrayRef and
uses a custom SQL query that pulls down only the ticket ids, instead?
More information about the Rt-devel