You are not logged in.
Pages: 1
Hi ab,
Just start playing with ZEOS + Postgresql.
What I find out is when try to set remote server and/or port in TSQLDBZEOSConnectionProperties.URI() class function where if aLibraryLocation='' then we exit and miss the chance to set result+'//'+aServerName
Offline
Indeed.
(on our side, we always specified the library, for safety about potential issues in the Windows path)
We have just fixed TSQLDBZEOSConnectionProperties.URI() when aLibraryLocation=''.
See http://synopse.info/fossil/info/60c0380334
Thanks for the feedback.
Offline
Also,
CreateMissingTables() seems to explicit create unique index by id:
CREATE UNIQUE INDEX ndxsamplerecordid ON public.samplerecord USING btree (id);
but Postgresql creates index on the fly when PrimaryKey Constraint specified in Create Table:
CREATE TABLE public.samplerecord (
id INTEGER NOT NULL,
...
CONSTRAINT samplerecord_pkey PRIMARY KEY(id)
)
All tables end up with duplicate index for primary id key.
Extra index, extra disk size, extra row update time.
Offline
Indeed.
I tried to check the databases which are known to create indexes on primary key.
It is not clear to me if DB2 does create it or not...
And in all cases, we create a descending index for FireBird, so that SELECT maxid from max(ID) performance is maximimized.
Offline
Pages: 1