Magento

Hello, All!

I have a working module that is extremely slow because I’m having to get my model’s resource as a collection then iterate through the values each time I want to get a specific row.

My module uses a custom resource entity that is just a standard table with 4 columns:
id
customer_id
sku_id
price

I need to query the table by customer_id, sku_id. I know this has to be possible, but I can’t find any examples. Anybody have some incite?

You may have a look at the core class \’Mage_Sales_Model_Mysql4_Quote\’->loadByCustomerId. This loads all the sales quotes of a particular customer. Should give you some idea of how to do it.