Solution for ZEOS 6.6.6 with >= FPC2.5.x

sem-evgen · Post by **sem-evgen** » 28.11.2012, 17:50

Thanks, i will try.

sem-evgen · Post by **sem-evgen** » 28.11.2012, 19:55

last working fast revision is 905. 906 is slow
diff:

--- 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

sem-evgen · Post by **sem-evgen** » 28.11.2012, 20:07

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 ))

Post by **EgonHugeist** » 28.11.2012, 21:49

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.

sem-evgen · Post by **sem-evgen** » 28.11.2012, 22:48

Sorry for my English =)