Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Create Table is Sql is more slower than create in delphi code
Fri, Jan 27 2006 5:44 AMPermanent Link

"Stefano Monterisi"
Hi Tim,
I have noted (latest 4.xx release) that creation of table with sql is slower
that the same table created from code;
for the exactitute, the same table that is created in dbisam 3 delphi
code.....is faster a lot of  the same creation in Sql with release 4; (I am
in porting from dbisam 3 to 4, changed table code generation with SQL
commands);
There is a reason, bug, etc...?
Or table creation is slower in Dbisam 4 in general?

Thanks in advance,

Stefano Monterisi

Fri, Jan 27 2006 9:44 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Stefano,

<< I have noted (latest 4.xx release) that creation of table with sql is
slower that the same table created from code; for the exactitute, the same
table that is created in dbisam 3 delphi code.....is faster a lot of  the
same creation in Sql with release 4; (I am in porting from dbisam 3 to 4,
changed table code generation with SQL commands);  There is a reason, bug,
etc...? Or table creation is slower in Dbisam 4 in general? >>

How much of a difference are we talking about ?  The creation of a table
usually only takes a few milliseconds, at most, so if you're seeing more
than that then there's something else going on (hard drive, etc).

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Jan 28 2006 4:15 AMPermanent Link

"Stefano Monterisi"
Uhmmm.....
I will try with the current application in porting;
The slowdown I have noted is on a application that I don't manage
directly....so I don't known if there are particular events or similar in
that application....
So, I will try directly in my current application, so I could be more
precise......

Good job, Tim.

Stefano Monterisi


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> ha scritto nel
messaggio news:B8424BA9-5164-4CB3-9F0E-F4BDBDB3370C@news.elevatesoft.com...
> Stefano,
>
> << I have noted (latest 4.xx release) that creation of table with sql is
> slower that the same table created from code; for the exactitute, the same
> table that is created in dbisam 3 delphi code.....is faster a lot of  the
> same creation in Sql with release 4; (I am in porting from dbisam 3 to 4,
> changed table code generation with SQL commands);  There is a reason, bug,
> etc...? Or table creation is slower in Dbisam 4 in general? >>
>
> How much of a difference are we talking about ?  The creation of a table
> usually only takes a few milliseconds, at most, so if you're seeing more
> than that then there's something else going on (hard drive, etc).
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Image