Query length restriction in v3 protocol?
От | Patric Bechtel |
---|---|
Тема | Query length restriction in v3 protocol? |
Дата | |
Msg-id | 4460B977.9070005@ipcon.de обсуждение исходный текст |
Ответы |
Re: Query length restriction in v3 protocol?
|
Список | pgsql-jdbc |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I'm struggling with hibernate and postgresql, because after some performance analysis, it seems that it's wise to use table per concrete class mapping, which means that all polymorphic queries result in huge (I mean, very huge) union queries. The question that I have is, if there's any length restriction regarding on commands sent to the backend. I've seen queries 1.5 MB long, is that really a problem or is there another solution for that (could be that it's only possible with views in between or such)? Normally I wouldn't even dare to send such beasts to the backend because I would worry about parsing times and such, but I've seen the performance of outer join queries over 5-9 tables (=inheritance depth in O/R model), which is even more scary... Thanks in advance, - -- Mit freundlichen Gruessen / Regards Patric Bechtel, IPCON Informationssysteme OHG Kontakt: http://www.ipcon.de/kontakt.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: GnuPT 2.5.2 iD8DBQFEYLl2fGgGu8y7ypARAktCAKDMOBCM/1DviG0xGJ+TWHM2By6ZSACgjPxC GdcrQsQkZeO5+hO9yF0jdKU= =cFRc -----END PGP SIGNATURE-----
В списке pgsql-jdbc по дате отправления: