-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
I am not sure to modify the implementation of ResultSetMetaDataFactory properly. Anyway, thanks a lot for the help you provide me. Emmanuel Cecchet escribió: > Hi Ruben, > >> Some database details: >> Tables: 228 >> Views: 75 >> >> The "table2" table is one of the biggest in our database >> Number of columns: 118 >> > If you look at the code in SequoiaResultSetMetaDataFactory, we fetch a > number of metadata individually for each column. Unfortunately it seems > that the Postgres driver transforms every call into an inefficient query > which shows this poor performance. > The metadata cache will certainly improve performance but not of the > first request. The Postgres driver could probably be improved to fetch > all metadata at once.If there is metadata that you never access, you can > create your own ResultSetMetaDataFactory by removing the info your don't > need from the SequoiaResultSetMetaDataFactory. > > Hope this helps, > Emmanuel > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJUL6cIo1XmbAXRboRAu0uAJ9Dw2DFAGAHa6IPirUvub3wc2fi6QCdH4hn iQFi0NGU2Pz4Q5zKGCtfno8= =nJ/6 -----END PGP SIGNATURE-----
begin:vcard fn:Ruben Rubio n:Rubio;Ruben org:Rentalia Holidays S.L adr;quoted-printable:;;Gran v=C3=ADa 31, 9=C2=BA-1=C2=BA;Madrid;;;Spain email;internet:[email protected] tel;work:+34915233104 url:http://www.rentalia.com version:2.1 end:vcard
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
