We are developing an application (using .Net in MS Studio 2003 using the
Access jet engine as a backend) that is doing quite a bit of number
crunching. The first part of the application was written using collections,
but we have now found that manipulating the data in virtual tables
(datasets) seems a better way to go. However, we have not attempted to
rewrite the previous code to compare the processing of one compared to the
other. Has anyone else had experience with this?
5  1298 
Hi M Harris,
I had the the opposite experience. I started storing data into datasets
and datatables. But after some experiments returned to the simple and
effective arraylist, unbeatable as to performances... :)
Anyway, in general, probably the best decision depends on the general
architecture of you program and for the tasks you have to do. My
current thinking is that one should use the dataset only if he has to
maintain a sort of local database (tables, relationships,. ..) ...
Personally, I tend to stay far from datatables when possible ...
just my 2 cents
-tom
M Harris,
Datasets and Datatables are a kind of ultime implementations of Classes
which holds collections.
With that taking all the overhead from those classes which simple arrays
don't have.
Therefore if you want only an simple array, than you can use a simple
collection. If you want an class which has everything that you need to
handle data in it, than you can take a dataset (although it is in my opinion
not yet ready, there can be even more in it).
I hope this helps,
Cor
"M Harris" <mh*****@revenu e.state.il.us> schreef in bericht
news:%2******** ********@TK2MSF TNGP05.phx.gbl. .. We are developing an application (using .Net in MS Studio 2003 using the
Access jet engine as a backend) that is doing quite a bit of number
crunching. The first part of the application was written using
collections,
but we have now found that manipulating the data in virtual tables
(datasets) seems a better way to go. However, we have not attempted to
rewrite the previous code to compare the processing of one compared to the
other. Has anyone else had experience with this?
This is the same as
what is better a speedboat or a cruise liner ?
well if you want to go fast from a to b on a short distance i would prefer
the speedboat , however for crossing the ocean i would go for the cruise
liner
my personal aproach is :
go for the most lightweight aproach when apropriate and possible and now
when to hump on the cruiseliner ( you see often people extend there
speedboat untill it is almost sinking on its weight , it would have been
better to use the cruiseliner instead )
regards
Michel Posseth [MCP]
"M Harris" <mh*****@revenu e.state.il.us> schreef in bericht
news:%2******** ********@TK2MSF TNGP05.phx.gbl. .. We are developing an application (using .Net in MS Studio 2003 using the
Access jet engine as a backend) that is doing quite a bit of number
crunching. The first part of the application was written using
collections,
but we have now found that manipulating the data in virtual tables
(datasets) seems a better way to go. However, we have not attempted to
rewrite the previous code to compare the processing of one compared to the
other. Has anyone else had experience with this?
Lol but true, do you maybe have a free sight on the harbour?
Cor
Lol but true, do you maybe have a free sight on the harbour?
No.... but i live nearby the harbour ( a view to the harbour has a big
price these days in Rotterdam :-)
regards
Michel
"Cor Ligthert [MVP]" <no************ @planet.nl> schreef in bericht
news:e9******** ******@TK2MSFTN GP05.phx.gbl... Lol but true, do you maybe have a free sight on the harbour?
Cor
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Invalidlastname |
last post by:
Hi,
I have some questions regarding to use vs.net to generate xsd from database tables then generate classes, not typed datasets, from the xsd.
Basically I want to have some light-weigh classes to represent the database tables/views (I know tables/view are not business entities, but this is a good starting point and i am lazy =) Here are what I did:
- used xsd.exe to generate business entities, which will be used to be passed between...
|
by: Rob Thomas |
last post by:
Hi,
I've been tasked to come up with a new architecture for a large
application at one of my customer's sites.
In the past, I have developed multi-tier applications whereby the
business objects maintain the database using stored procedures etc and
provide the data to the GUI layer via a set of objects and collections.
After using the typed datasets with .NET, it appears that you van
provide the same functionality as objects and...
|
by: rodchar |
last post by:
hey all,
i was checking out time tracker on asp.net one of the starter kit projects.
i was wondering why the users datagrid gets loaded the way does. first it
pulls all the users in from a stored procedure into a dataset. next in the
code it iterates row by row instantiating a new user object and adding it to
a collection?
why would you do this when you can work directly with the dataset?
i'm very new to this just trying to understand...
|
by: Geoff Pennington |
last post by:
I have a class method that returns a DataAdapter. I want to access the
table(s) contained in the DataAdapter. Of course, accessing the DataSets
would be good enough, because I could get the tables from there. I can't
find a way to do this. Am I missing something?
Much obliged.
|
by: Raju Joseph |
last post by:
Hi All,
We are in the process of developing an N-Tier app using VB.NET. We are
extensively using classes (entity objects) in our design. Further, most of
the times, we do have to specify nested types within our entity classes.
For example
Public Class Country
ID as short
| | |
by: Dave |
last post by:
Please - anyone that can help.
I am getting confusing results while trying to expose a collection from a
web service.
I have a webservice in which a web method accepts a collection as a
parameter and returns an array of datasets. The collection consists of
database connection objects.
Based on the simple hierarchy below, you can see that starting with the
|
by: John Dalberg |
last post by:
I noticed the starterkits timetracker & issue tracker load data from a
database into custom collections (arraylists) which bind to a datagrid.
What are the advantages of using custom collections over simpler objects
like datareaders or datatables?
John Dalberg
|
by: balabaster |
last post by:
I have a database with two main tables, we'll call them A and B. The relationship between the two main tables is by nature a many-to-many relationship, so to normalize and avoid the many-to-many relationship, I've got a third table that joins relevant records of table A to table B, we'll call this one c.
So here I get to the tricky part and I wondered how most people got around this. I've got 2 classes in my project, one to represent table A...
|
by: =?Utf-8?B?QmV0aA==?= |
last post by:
Hello.
I'm trying to find another way to share an instance of an object with other
classes.
I started by passing the instance to the other class's constructor, like this:
Friend Class clsData
Private m_objSQLClient As clsSQLClient
Private m_objUsers As clsUsers
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
