On Jul 6, 2008, at 12:21 PM, [EMAIL PROTECTED] wrote:
>
> the query is ugly;
> seems count(1) counts the decart-product or something:
>
> SA: INFO SELECT count(1) AS count_1
> FROM "Otnoshenie", mm_nazn2rabmesto, mm_nazn2pozicia,
> mm_pozicia2otdel,
> mm_otdel2otdel AS mm_otdel2otdel, mm_otdel2otdel AS mm_otdel2otdel1,
> mm_otdel2otdel AS mm_otdel2otdel2, "PVOwnership" JOIN "ParamValue"
> ON "PVOwnership".param_value_id = "ParamValue".db_id
> WHERE "ParamValue".time_trans <= ? AND "ParamValue".time_valid >= ?
> AND "ParamValue".time_valid <= ? AND ("Otnoshenie".db_id
> = "PVOwnership"."_AbstractNaznachenie_id" OR "Otnoshenie".db_id =
> mm_nazn2rabmesto.left_id AND mm_nazn2rabmesto.right_id
> = "PVOwnership"."_Rabotno_miasto_id" OR "Otnoshenie".db_id =
> mm_nazn2pozicia.left_id AND (mm_nazn2pozicia.right_id
> = "PVOwnership"."_Pozicia_id" OR mm_nazn2pozicia.right_id =
> mm_pozicia2otdel.left_id AND (mm_pozicia2otdel.right_id
> = "PVOwnership"."_Otdel_id" OR mm_pozicia2otdel.right_id =
> mm_otdel2otdel.left_id AND (mm_otdel2otdel.right_id
> = "PVOwnership"."_Otdel_id" OR mm_otdel2otdel.right_id =
> mm_otdel2otdel1.left_id AND (mm_otdel2otdel1.right_id
> = "PVOwnership"."_Otdel_id" OR mm_otdel2otdel1.right_id =
> mm_otdel2otdel2.left_id AND mm_otdel2otdel2.right_id
> = "PVOwnership"."_Otdel_id"))))) AND "PVOwnership".param_value_id
> = "ParamValue".db_id AND "Otnoshenie".obj_id_id = ?
>
> that's 3 levels: 4752
> 4 levels: 14256
> 5 levels: 42768
> .. 8 levels: 1154736
> while there are 57 rows total.
I have no idea what that is. Is that a bunch of join()/filter()
you've added to the query before issuing count() ? or are you mapped
to a select() statement of that form ? (either way I dont see what
choice SA has in the matter...)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
