Board index » delphi » Re: Database components

2005-06-28 09:00:00 AM
delphi205
RemObjects/Datasnap and kbmmw were recommended, among other solutions.
'KingOrmon' decided he liked kbmmw because he thought RO/DA was too
expensive.
In my view, he has already been recommended the range of available n-tier
frameworks, and the only issue is which data access components he wants to
use for each specific database server. He listed Oracle, MS SQL Server, etc
as the db servers he wanted to use, but did not specify any criteria for
what he wanted of the databse components, whether he just wanted access, or
he wanted maximum speed. Maybe ADO meets his needs. ODAC, SDAC etc are
probably great, but since I find communication with 'KingOrmon' somewhat
difficult since he does not specify what he wants, criticises and questions
the solutions proposed, and does not acknowledge or thank contributors to
his threads, it won't be me who recommends them to him.
Regards,
Lauchlan M
 

I am sorry,
I want apologize you, Lauchlan M, and everybody that I could have offended
I am interested in all your posts:
I rewrite my necesities:
Support complex relationships (master/details) like datasnap.
ClientDataSet components
Speed is important. DataSnap is slow with multiple relationships
I use ADO components (in server layer)
C++Builder 6 Pro support
DataBases: MSDE2000, SQLSERVER, ORACLE 9i, MYSQL 4
thank you.
sorry for mi english.
 

Oh, I see, you are literally looking for *database*components*...
Oh Ok. I have been happy with the Delphi 7 ADO components as the method of
connectivity to all the "major" DB back-ends. I know there are ADO
replacements out there, but I personally have never needed to use them...
-- d
---------------------------------------------------
Need to see what's happening?
Check out the Delphi Community Blog Aggregator
delphi.flashblogger.com
"KingOrmon" <XXXX@XXXXX.COM>writes

is not your{*word*128}language.
don't use ClientDataSets, but use quivalents (eg the ClientDataTable in
DataAbstract).
at www.crlab.com/products.html , in particular ODAC, SDAC and MyDAC.
These support all the databases you mentioned, and are optimised for speed.
I have not used these myself, but they have been highly recommended.
For SQL Server and MSDE, there is also OLEDBDirect,
www.oledbdirect.com/index.php . I have used this, and the speed gains
were impressive. I gather SDCA/ODAC/MyDAC offer similar gains, as they also
target direct access to the OLEDB layer.
CoreLabs also offer classes for drect C++ access to Oracle.
Lauchlan M
 

Hi Dmitry,
Synapse because they feel it is easier and more powerful for some
applications. Also, plain classes, no components. Easier to install... You
can google the newsgroup for other opinions.
From the site www.ararat.cz/synapse/ : " This project is freeware and
open source under modified BSD style license!"
Also, from the site : also support for "Delphi 3-7, C++Builder, Kylix 1-3 or
FreePascal 1.0.10 - 1.9.6".
Add me for the PostgreSQL and FreePascal support for Oracle and PostgreSQL.
Keep up the good work!
Best Regards,
Oliver
 

Thank you Lauchlan M,
Your posts are very good.
I am thinking in use kbmmw + ADO. I donwloaded it
but I am waiting a password for unzip the file.
I need test the speed with multiple master/detail relationship.
datasnap is slowed with ADO and SQLSERVER:
test example:
1 MASTER TABLE WITH 1000 rows
2 DETAILS TABLES ~ 5 rows per each master record
the open time is over 40 seconds
"Lauchlan M" <LMackinnonAT_NoSpam_ozemailDOTcomDOTau>escribi?en el mensaje

I suggest you get together a basic example using the ADO components (follow
the kbmmw introductory white papers which uses the BDE, but you can just
replace the BDE components with the corresponding ADO ones) and then look
into the cross adapter components, for multi-database support. The idea of
the kbmmw cross database components is to support the app using multiple
database servers. To find out more, I suggest you ask about these components
on the kbmmw ng.
opening two tables in a master/detail relationship, with a total of 1000
records in one and 5000 in the other?
But the speed really depends on a lot of things. Do the master or detail
records contain any BLOBs or other sizeable data? Is this over a LAN or WAN?
If it is a WAN, what kind of connection do you have, eg dial-up or broadband?
What transports are you using (eg is it Indy components)? etc.
Also, I know you are doing testing, but normally for n-tier design you try
to design it so you download the minimum number of rows required. So you ask
the user to put in some filter criteria first, and only download the rows
that are currently required by the user. But in testing, of course, this is
irrelevant.
Anyhow, since this is now about using kbmmw, I suggest you ask on the kbmmw
ng. There are many experienced kbmmw users there who can help you.
HTH
Lauchlan M
 

Hello, Lauchlan M
I have install the kbmMW under C++Builder 6 Pro and it is very complex for
install.
RemObjects/DataAbstract don´t support C++Builder 6 Pro ?
I am thinking in change my requirements to:
DataBase components that supports complex relation ship like ClientDataSet.
Resolving conflicts, but without app layer server.
Thanks !
 

some help from their ng.
Alternatively, you could look at using the kbmmemtable (an in-memory dataset
table) as a basis for your architecture.
Lauchlan M
 

Hi,
steps to pursue).
If it will be the correct path to choose, I dont know, as I dont know your exact requirements.
However in most cases, a thin client is to prefer over a fat one where you need to configure database access API's and
more.
--
best regards
Kim Madsen
XXXX@XXXXX.COM
www.components4developers.com
The best components for the best developers
kbmMW - RAD Enterprise class n-tier application server framework
kbmMemTable - High performance memory table
kbmWABD - RAD web development
kbmX10 - RAD house automation
 

Lauchlan M
 

Please, I am sorry for my english.
I dont know how transmit my requeriments:
I need work on this way:
see the inherintance of master/details in clientdataset
bdn.borland.com/article/0,1410,30330,00.html (in spanish)
thank you.
"Lauchlan M" <LMackinnonAT_NoSpam_ozemailDOTcomDOTau>escribi?en el mensaje