| Subject | (Getting OT:) Re: Converting from BDE/dBase to Firebird |
|---|---|
| Author | tomc7777777 |
| Post date | 2011-07-26T15:38:48Z |
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
1. Mature product of excellent quality.
2. Support is outstanding.
3. Found the performance very good.
4. One unified API.
5. High speed, low memory and solid technology.
6. Tracing capabilities.
7. Automatic source translation for BDE based applications.
Specials
1. RefreshRecord() allows refreshing 1 rec in recordset
2. Can add multiple result sets to a TADQuery or TADMemTable
3. The TADQuery has an internal TADMemtable
4. Didn't have to generate various update/insert/delete SQL.
5. see https://anydac.uservoice.com/forums/89337-general
Re: Array DML
http://www.da-soft.com/anydac/docu/Very_High_Performance_using_the_Array_DML.html
"Obviously, the resulting performance will differ based on the server implementation; especially Oracle, Microsoft SQL Server and IBM DB2 have very powerful support of the Array DML and the resulting performance increase is just amazing. "
Lastly, IMO it seemed that IBO/Jason lost interest and the component set started to feel neglected.
Tom
>Hi Set,
> > Having used both anydac and ibo, both will do the job but anydac is
> > imo quite superior (http://www.da-soft.com/anydac/)
>
> Getting offtopic, but never having used anydac, I'm curious about your reasons. The two reasons I could immediately appreciate from looking at their home page, was the ability to use different database servers (e.g. I cannot use IBO to connect to MS SQL Server) and the array DML (is it really possible to reach one hundred thousand rows per second with Firebird? I normally get less than ten thousand rows per second with IBO).
>
> On the other hand, this question was originally about BDE/dBase to Firebird, and IBO does have a recipe for how to convert from BDE to IBO in a matter of a few seconds or minutes (albeit that is from BDE/<InterBase or Firebird> to IBO/<InterBase or Firebird> and doesn't include the bigger step of getting from dBase to Firebird). It seems like anydac has something similar, so Charlie has a fair choice.
>
> Set
>
> Getting offtopic, but never having used anydac,Quick go for you:
> I'm curious about your reasons.
1. Mature product of excellent quality.
2. Support is outstanding.
3. Found the performance very good.
4. One unified API.
5. High speed, low memory and solid technology.
6. Tracing capabilities.
7. Automatic source translation for BDE based applications.
Specials
1. RefreshRecord() allows refreshing 1 rec in recordset
2. Can add multiple result sets to a TADQuery or TADMemTable
3. The TADQuery has an internal TADMemtable
4. Didn't have to generate various update/insert/delete SQL.
5. see https://anydac.uservoice.com/forums/89337-general
Re: Array DML
http://www.da-soft.com/anydac/docu/Very_High_Performance_using_the_Array_DML.html
"Obviously, the resulting performance will differ based on the server implementation; especially Oracle, Microsoft SQL Server and IBM DB2 have very powerful support of the Array DML and the resulting performance increase is just amazing. "
Lastly, IMO it seemed that IBO/Jason lost interest and the component set started to feel neglected.
Tom