does anyone have any ideas on this? Is there a way to jump right to a category listing page in the back end to see if i can get around this issue of trying to load every product?
On Dec 15, 2:59 pm, Bobby Roberts <[email protected]> wrote: > i'm using v0.9 it's running a massive sql statement as shown here: > > SELECT `product_product`.`id` , `product_product`.`site_id` , > `product_product`.`name` , `product_product`.`slug` , > `product_product`.`sku` , `product_product`.`short_description` , > `product_product`.`description` , `product_product`.`items_in_stock` , > `product_product`.`meta` , `product_product`.`date_added` , > `product_product`.`active` , `product_product`.`featured` , > `product_product`.`ordering` , `product_product`.`weight` , > `product_product`.`weight_units` , `product_product`.`length` , > `product_product`.`length_units` , `product_product`.`width` , > `product_product`.`width_units` , `product_product`.`height` , > `product_product`.`height_units` , `product_product`.`total_sold` , > `product_product`.`taxable` , `product_product`.`taxClass_id` , > `product_product`.`shipclass` , > `product_product`.`BinderFermentation_id` , > `product_product`.`BinderYear_id` , > `product_product`.`BinderSeed_id` , > `product_product`.`BinderCuring_id` , > `product_product`.`BinderCountry_id` , > `product_product`.`BinderRegion_id` , > `product_product`.`FillerFermentation_id` , > `product_product`.`FillerYear_id` , > `product_product`.`FillerSeed_id` , > `product_product`.`FillerCuring_id` , > `product_product`.`FillerCountry_id` , > `product_product`.`FillerRegion_id` , > `product_product`.`WrapperColor_id` , > `product_product`.`WrapperFermentation_id` , > `product_product`.`WrapperYear_id` , > `product_product`.`WrapperSeed_id` , > `product_product`.`WrapperCuring_id` , > `product_product`.`WrapperCountry_id` , > `product_product`.`WrapperRegion_id` , > `product_product`.`Strength_id` , `product_product`.`Ring_id` , > `product_product`.`Shape_id` , `django_site`.`id` , > `django_site`.`domain` , `django_site`.`name` , > `elmago_fermentation`.`Id` , > `elmago_fermentation`.`FermentationType` , > `elmago_fermentation`.`DateAdded` , `elmago_yearproduced`.`Id` , > `elmago_yearproduced`.`YearOfProduction` , > `elmago_yearproduced`.`DateAdded` , `elmago_typeofseed`.`Id` , > `elmago_typeofseed`.`SeedType` , `elmago_typeofseed`.`DateAdded` , > `elmago_typeofcuring`.`Id` , `elmago_typeofcuring`.`CureType` , > `elmago_typeofcuring`.`DateAdded` , `elmago_countryoforigin`.`Id` , > `elmago_countryoforigin`.`CountryName` , > `elmago_countryoforigin`.`DateAdded` , `elmago_region`.`Id` , > `elmago_region`.`RegionName` , `elmago_region`.`DateAdded` , T9.`Id` , > T9.`FermentationType` , T9.`DateAdded` , T10.`Id` , > T10.`YearOfProduction` , T10.`DateAdded` , T11.`Id` , T11.`SeedType` , > T11.`DateAdded` , T12.`Id` , T12.`CureType` , T12.`DateAdded` , > T13.`Id` , T13.`CountryName` , T13.`DateAdded` , T14.`Id` , > T14.`RegionName` , T14.`DateAdded` , `elmago_color`.`Id` , > `elmago_color`.`ColorName` , `elmago_color`.`DateAdded` , T16.`Id` , > T16.`FermentationType` , T16.`DateAdded` , T17.`Id` , > T17.`YearOfProduction` , T17.`DateAdded` , T18.`Id` , T18.`SeedType` , > T18.`DateAdded` , T19.`Id` , T19.`CureType` , T19.`DateAdded` , > T20.`Id` , T20.`CountryName` , T20.`DateAdded` , T21.`Id` , > T21.`RegionName` , T21.`DateAdded` , `elmago_strength`.`Id` , > `elmago_strength`.`StrengthLevel` , `elmago_strength`.`DateAdded` , > `elmago_ring`.`Id` , `elmago_ring`.`RingGuage` , > `elmago_ring`.`DateAdded` , `elmago_shape`.`Id` , > `elmago_shape`.`ShapeType` , `elmago_shape`.`DateAdded` > FROM `product_product` > INNER JOIN `django_site` ON ( `product_product`.`site_id` = > `django_site`.`id` ) > INNER JOIN `elmago_fermentation` ON > ( `product_product`.`BinderFermentation_id` = > `elmago_fermentation`.`Id` ) > INNER JOIN `elmago_yearproduced` ON > ( `product_product`.`BinderYear_id` = `elmago_yearproduced`.`Id` ) > INNER JOIN `elmago_typeofseed` ON ( `product_product`.`BinderSeed_id` > = `elmago_typeofseed`.`Id` ) > INNER JOIN `elmago_typeofcuring` ON > ( `product_product`.`BinderCuring_id` = `elmago_typeofcuring`.`Id` ) > INNER JOIN `elmago_countryoforigin` ON > ( `product_product`.`BinderCountry_id` = > `elmago_countryoforigin`.`Id` ) > INNER JOIN `elmago_region` ON ( `product_product`.`BinderRegion_id` = > `elmago_region`.`Id` ) > INNER JOIN `elmago_fermentation` T9 ON > ( `product_product`.`FillerFermentation_id` = T9.`Id` ) > INNER JOIN `elmago_yearproduced` T10 ON > ( `product_product`.`FillerYear_id` = T10.`Id` ) > INNER JOIN `elmago_typeofseed` T11 ON > ( `product_product`.`FillerSeed_id` = T11.`Id` ) > INNER JOIN `elmago_typeofcuring` T12 ON > ( `product_product`.`FillerCuring_id` = T12.`Id` ) > INNER JOIN `elmago_countryoforigin` T13 ON > ( `product_product`.`FillerCountry_id` = T13.`Id` ) > INNER JOIN `elmago_region` T14 ON > ( `product_product`.`FillerRegion_id` = T14.`Id` ) > INNER JOIN `elmago_color` ON ( `product_product`.`WrapperColor_id` = > `elmago_color`.`Id` ) > INNER JOIN `elmago_fermentation` T16 ON > ( `product_product`.`WrapperFermentation_id` = T16.`Id` ) > INNER JOIN `elmago_yearproduced` T17 ON > ( `product_product`.`WrapperYear_id` = T17.`Id` ) > INNER JOIN `elmago_typeofseed` T18 ON > ( `product_product`.`WrapperSeed_id` = T18.`Id` ) > INNER JOIN `elmago_typeofcuring` T19 ON > ( `product_product`.`WrapperCuring_id` = T19.`Id` ) > INNER JOIN `elmago_countryoforigin` T20 ON > ( `product_product`.`WrapperCountry_id` = T20.`Id` ) > INNER JOIN `elmago_region` T21 ON > ( `product_product`.`WrapperRegion_id` = T21.`Id` ) > INNER JOIN `elmago_strength` ON ( `product_product`.`Strength_id` = > `elmago_strength`.`Id` ) > INNER JOIN `elmago_ring` ON ( `product_product`.`Ring_id` = > `elmago_ring`.`Id` ) > INNER JOIN `elmago_shape` ON ( `product_product`.`Shape_id` = > `elmago_shape`.`Id` ) > ORDER BY `django_site`.`domain` ASC > LIMIT 100 > > the elmago tables are custom tables for this particular client using > foreign key relationships. I checked and each table has the proper > primary key index setup. I think the issue is the fact that it's > trying to call every field out of the product table. Where can i edit > this for the listing or is there something else i can do? It > shouldn't tank on only 3500 products. -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
