Re: .Net framework and VB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I my experience, all DB operation puts locks on the tables so as the
read operation. But if u have both the method in one calss and many
user is calling any one of the method then locks will not be release
from database so your read operation will take same anout of time as
write operation but in reality read operaiton is faster then write
operation as it puts less lock.

So by seperating read and write u can achive a good performace in very
large Distrubuted application.

Norman Yuan wrote:

I do not understand you claim.

For example:

My ClassA has two methods to retreive data from DB and update DB:

ClassA.GetDataFromDB()
ClassA.UpdateDataToDB()

Then, you build two classes, each has only one method

ClassA.GetDataFromDB()
ClassB.UpdateDataToDB()

Assume all logics in the two methods are the same. Why your class' method
call is faster than mine? There should not be any difference on the process
of the method being executed, whether it is done in classical VB or .NET.

"Prateek" <prateekbaxi@xxxxxxxxx> wrote in message
news:1151674887.103666.126870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have recently started coding and designing the ,.NET based system
using different technology involved in .NET and well from the subject
line of this post, it is obvious that I am coming from a VB background.



I have many years of expirance in designing distributed system based on

VB, C++ and SQL Server but when I have tried .NET it is a complete new
exerince for me and I am not hesitant in saying this is a damm cool
stuff from MS.


Now in this regards, I got a question but I am really not sure what is
the case in .NET.


In earlier days, when I used to design classes based on limited VB
object based model, we used to create 2 different callses for one
business component. One class which is used for all database read
operation and another for database write, update and delete opeation.
Now, why we were doing this so because of the locking in database via
VB programs. if all database select operation id seperated from
database write operation it palces less locks and almost comes out
immediatly by removing database locks (Offcorse when all the VB dlls
are regirsted in COM+). Now I wanted know is this still applicable in
.NET.


For example, if I want to write a Cusomter business component, do I
still have to seperate out the select and updates in seperate classes.

In earlier days, I used to designed a dll with following classes.


CustomerRead (Main class to read, exposed to world)
CustomerWrite (Main class to write, exposed to world)
CustomerSingleSelect - a calss which gets data from customer based on
primary key and always return me a sigle row
CustomerMultiSelect - a class which gets the data from customer where
select operation is not based on its primay key.
CustomerModify - a class to modify customer.


Belive me this approch was much faster then everything in one class.
But this was the case in VB time. Does this still a case in .NET?


Thanks & Regards,


pb


.

Relevant Pages

  • Re: .Net framework and VB
    ... Whether the code is all in one class or not has nothing to do with database ... all DB operation puts locks on the tables so as the ... I have many years of expirance in designing distributed system based on ... CustomerSingleSelect - a calss which gets data from customer based on ...
    (microsoft.public.dotnet.framework)
  • Re: Considering using Access
    ... As a business owner, I imagine you do not have time to ... If designing a database was a simple task, ... I am thinking each customer will be assigned a number, ...
    (microsoft.public.access.tablesdbdesign)
  • .NET Framwork and VB
    ... I have many years of expirance in designing distributed system based on ... operation and another for database write, ... still have to seperate out the select and updates in seperate classes. ... CustomerSingleSelect - a calss which gets data from customer based on ...
    (microsoft.public.dotnet.framework.compactframework)
  • .Net framework and VB
    ... I have many years of expirance in designing distributed system based on ... operation and another for database write, ... still have to seperate out the select and updates in seperate classes. ... CustomerSingleSelect - a calss which gets data from customer based on ...
    (microsoft.public.dotnet.framework)
  • Re: Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... > UDQ Services has years of experience with MS Excel and VBA (Visual Basic ... > templates, spreadsheet applications, and database applications. ... > P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.worksheet.functions)