Page 3 of 3
Posted: 28.11.2012, 17:50
by sem-evgen
Thanks, i will try.
Posted: 28.11.2012, 19:55
by sem-evgen
last working fast revision is 905. 906 is slow
diff:
Code: Select all
--- C:/Users/sem/AppData/Local/Temp/ZDbcPostgreSqlMetadata.pas-rev905.svn000.tmp.pas Вт янв 19 02:06:36 2010
+++ C:/Users/sem/AppData/Local/Temp/ZDbcPostgreSqlMetadata.pas-rev906.svn000.tmp.pas Пт авг 12 01:10:23 2011
@@ -1958,7 +1958,9 @@
begin
SQL := SQL + ' AND n.nspname LIKE '
+ EscapeString(SchemaPattern);
- end;
+ end else begin
+ SQL := SQL + ' AND pg_table_is_visible (c.oid) ';
+ end;
end
else
begin
Posted: 28.11.2012, 20:07
by sem-evgen
i just comment this strings
Code: Select all
end else begin
SQL := SQL + ' AND pg_table_is_visible (c.oid) ';
and query works 7 times faster, thanks all for help ))
Posted: 28.11.2012, 21:49
by EgonHugeist
sem-evgen,
thank you for your help and sorry for the many mistakes in previous posts. Writing english with a german smartphone.. (:
I made a full testrun with our suites. No issues to see. Patch applied Rev. 2057 \testing (SVN) in trunk and testing-7.1 next week.
Posted: 28.11.2012, 22:48
by sem-evgen
Sorry for my English =)