command builder or table adapter...

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
rbirnesser
Posts: 37
Joined: Fri 11 Feb 2005 19:18

command builder or table adapter...

Post by rbirnesser » Wed 08 Nov 2006 18:14

I was wondering performance wise which one is better to use using 3.50 and visual studio 2005. Also what type of concurrency checking to use when using these data objects. Will using the compression protocol on your wonderful provider help speed things up a bit or not ?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 09 Nov 2006 10:39

I was wondering performance wise which one is better to use using 3.50 and visual studio 2005.
We behave the same way as standard ADO.NET components.
Also what type of concurrency checking to use when using these data objects.
Use default - Optimistic Locking.
Will using the compression protocol on your wonderful provider help speed things up a bit or not ?
Compressing data leads to reducing network traffic, in exchange for CPU usage on both client and server sides. To obtain performance gains, use Compress property when transferring BLOB fields.

rbirnesser
Posts: 37
Joined: Fri 11 Feb 2005 19:18

awesome...

Post by rbirnesser » Thu 09 Nov 2006 13:37

With the optimistic locking do i need to make a time stamp field on each table or am i thinking of something else. Does the command builder and table adapter both use optimistic locking by default ?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 10 Nov 2006 12:15

For optimistic locking you may include all table fields in the key fields.

rbirnesser
Posts: 37
Joined: Fri 11 Feb 2005 19:18

thanks...

Post by rbirnesser » Fri 10 Nov 2006 12:41

Thanks for your help i did some research on the commandbuilder and what i have concluded its probally better to use the table adapter to pre generate the statements for that table. Also did some research on optimistic locking and it seems like a good practice, and a timestamp field is not needed with it. Does MySQL server 5.0 i believe turns compression on by default ?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 10 Nov 2006 12:54

No. It fully depends on connection options.

Post Reply