Zeoslib Portal

Thanks,

I will check if i can disable some triggers. For Autocommit, I have found this already and it is set to false.

I have to read Postgres doc (I already read lot of it to learn SQL language).

Rgds

dear andresayang you may optimize your mysql server configuration to handling it with the good chosen engine ... such as InnoDB. Manz Sorry, I am working with Postgres ! But I started with Zeoslib, my small soft is working perfectly for what i want to do with it. The normal way of working is with S...

Thanks mdaems

I have notice that if I send a sql stringlist containing 2 files at the same time (ie 160 000 inserts), it is faster than sending them separately. That was why I was asking if there was any parameters to change to increase the speed.

Hi, Well, as far as I know, Zeos 7 is more or less working with D7, D2010 and Lazarus. For D7 and Lazarus, you should use Zeos 6.6.5 which is stable. For D2010, you can try Zeos7, which will work for most of the cases, but you must know that it is still in Alfatest stage (so should not be use in pro...

Hi, I will have a look !

The thing is that my code was quite simple at the beginning: Backup one database and restore the backup inside another one.

But now, the app is doing more and more and I only adapted the fisrt codding and would like to preserve it (to do not rebuild all from 0).

Thanks

Hi With delphi 2007, i have lot of Insert commands to execute I do something like this: var Connection: IZConnection; Statement: IZStatement; ... Statement:= Connection.CreateStatement; Statement.ExecuteQuery(sqltosend.Text); Statement.Close; ... sqltosend is a StringList containing more or less 80 ...

I have same problem restoring a db from postgres 8.3 to postgres 8.4.
Th 8.3 was window locale encoding and the 8.4 was UTF8 encoding.

I have to drop all "suspicious characters" to make it work.

Hope this help !

Mark, Well your proposal is really a better solution. I have already done those change when you reply and i have post the working files after. (simply because i think it is how it should be: disabling a database support with the Zeos.inc file was failing the compilation). However the size drop is qu...

Only to show how to disable databases supports in modified Zeos.inc.

Hi all,

Well I have found the answer myself by testing.
I have to modify 3 files, included inside the 7z archive.

For the modification in the Zeos.inc file, I think it is more easy now to enable/disable any database support.

Hope this will help a little.

Hi,

Well in the Zeos.inc file there is:

{$IFNDEF ZEOS_DISABLE_POSTGRESQL}
{$DEFINE ENABLE_POSTGRESQL}
{$ENDIF}

Is there other file where we define ZEOS_DISABLE_POSTGRESQL or we should do it in the Zeos.inc file ?


Thanks

Hi, Should it be possible to have TTimeStamp or TSQLTimeStamp output for this function ? The reason is that I 'm working on a database storing GPS times and i absolutely need microseconds resolution. I already modify the unit to output the "lateral" result as a string but if it could be im...

GTO you're right, Delphi search for BPL and DCU files into C:\Documents and Settings\All Users\Documentos\RAD Studio\6.0\Bpl I've copy my file to there and it's work. But, where can I change this parameter into the Delphi 2009 IDE, to make Delphi search on my folder? Or better, can I configure this...

Ok,

Thanks. In fact I already found those files but i did not know it was the latest.

rgds

Hi,

Well I'm afraid that my company does not allows svn protocol (or i do not know how to use tortoise svn).

Is there any place where i can download the latest version ?

I would also like to congratulate the Zeos team, wonderful soft !

Thanks