Re: Connect over internet
- From: "Edwin Walker" <EdwinWalker@xxxxxxxxxxx>
- Date: Thu, 22 Jun 2006 10:30:10 -0500
Ian,
1) Yes, AFAIK, that is how most drivers, thin or fat works.
2) Yup, I would think that most thin middleware programs do the same. I
know ASTA does, and it allows you to configure, override, etc.
3) ASTA also does this and more. I am sure that others do the same, but I
dont know.
I mention ASTA a lot, that is the only thin middleware software that I have
used. I know RemObjects has a very powerful thin frameworks, I am sure that
if you visit some of their websites, they could provide you with lots of
info why using thin is good, or IMO better.
ASTA had a feature that would encrypt and compress data before sending it
over the wire and de-crypt and de-compress on the client side. Which was a
nice feature, I am sure others do the same.
You are right, you COULD use ADO in connecting over the net, but should you.
Maybe in your application you were able to get good performance but I dont
think this is the norm.
Maybe MySQL works very different then MS SQL-Server. I have only worked
with MS SQL-Server so I only have that to draw on. It is my understanding
that with ADO with MS-SQL Server each client has a direct connection to the
database, this becomes a problem when you have many clients all doing
different things. With thin models, you return the whole result set,
present it to the user and then only send updates back to the server. I
think MIDAS works that way.
I also think ADO.NET works on this model also.
Thanks for you feedback and I will look a little more closely at MySQL. I
have some projects comming up that are should be thin and maybe this is a
way to go. Maybe
Edwin
.
- References:
- Connect over internet
- From: Alan
- Re: Connect over internet
- From: Guillem
- Re: Connect over internet
- From: Edwin Walker
- Re: Connect over internet
- From: Guillem
- Re: Connect over internet
- From: Alan T
- Re: Connect over internet
- From: Edwin Walker
- Re: Connect over internet
- From: Ian Hinson
- Connect over internet
- Prev by Date: CDS, Query and Access
- Next by Date: TADODataset does not want to post records
- Previous by thread: Re: Connect over internet
- Next by thread: Re: Connect over internet
- Index(es):
Relevant Pages
|