Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Create Table is Sql is more slower than create in delphi code |
Fri, Jan 27 2006 5:44 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 > > |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |