Zeoslib Portal

Sorry for my English =)

i just comment this strings and query works 7 times faster, thanks all for help ))

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

Thanks, i will try.

Yes, Zoran right. I don't know how i can do diff between all source files of Zeos. Now i use FPC 2.4.3 + ZEOS 6.6.6 stable

i have create component dynamically FConnection := TZConnection.Create(nil); FConnection.Protocol:= 'postgresql-8'; FConnection.HostName:= POSTGRESQLIP; FConnection.Port:= POSTGRESQLPORT; FConnection.User:= DBUSR; FConnection.Password:= DBPASS; FCOnnection.Database:= DBNAME; FSQLQuery := TZQuery.Cre...

I used fpc 2.4.3 and zeos 6.6.6 which i download when it was released with this set "SELECT" works fast. I update fpc to 2.6.0 and can't compile executable, i download zeos 7.0 beta, compile, test it and see that quary is slow. i download lastest zeos 6.6.6 from svn and compile executable ...

SQL query looks like: SELECT (SELECT firstname FROM users WHERE users.id = history_1815.executorid) as fname, (SELECT secondname FROM users WHERE users.id = history_1815.executorid) as sname, (SELECT thirdname FROM users WHERE users.id = history_1815.executorid) as tname, id, direction, executorid, ...

Sorry, but i mixed up old and new executable files, and now i understand that execution with new compiler and new zeos still slow with SELECT query

Thank you, it works.

I don't know where i can ask question and i decide to write that here. Recently i had update FPC to versiov 2.6 and LAZARUS to 1.0.2 and got problem with project compilation. Then i update zeos to 7.0 beta, project successfully compiled but i see that some queries to Postgresql DB became about 7 tim...