I am looking for a collection or a way to solve the following problem,
any insight would be greatly appreciated.
I am developing a VB .NET application that reads values from SQL server
and stores them in memory, I am doing this because of the frequency of
their use. The individual values alone are not unique, but as a trio
they are.
For example my collection may look like the following:
ID, DOC, SCAC
1,XX, XXX
1,YY,XXX
2,XX,XXX
Now I am looking for a good way to search the collection, so that i can
pass a specific ID, Doc, and SCAC and see if those values exist as a
trio. I need to do this as efficiently as possible.
Thanks. 4 1838 sc**********@gmail.com wrote: I am looking for a collection or a way to solve the following problem, any insight would be greatly appreciated.
I am developing a VB .NET application that reads values from SQL server and stores them in memory, I am doing this because of the frequency of their use. The individual values alone are not unique, but as a trio they are.
For example my collection may look like the following: ID, DOC, SCAC 1,XX, XXX 1,YY,XXX 2,XX,XXX
Now I am looking for a good way to search the collection, so that i can pass a specific ID, Doc, and SCAC and see if those values exist as a trio. I need to do this as efficiently as possible.
Thanks.
If you don't have an astronomical amount of data, a datatable with the
three columns as the index works pretty well. What quantity of records
are you talking about here?
T
The amount of data could be anywhere from a couple of records to a
hundred or so records per person. sc**********@gmail.com wrote: The amount of data could be anywhere from a couple of records to a hundred or so records per person.
Per person? Cuantas personas hay?
Disregard that, each time the data is retrieved it will contain roughly
100 records. I also am wondering how to search the dataset once i have
it. Say I want to find a certain row, is that possible? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: sugaray |
last post by:
I don't get why the correct way to allocate memory space for
3d-array should be like this in C++:
long (*ptr);
ptr=new long;
and when deallocation
delete ptr;
|
by: Cant Think Today |
last post by:
I have multi-dimesional arrays that can be specifed by the user, e.g
1,2,3,4,5
1,2,3,4,5,6,7,8,9,10
1,2,3,4,5,6
I think a bit of code that will iterate over these arrays to print out
the...
|
by: Adam Hartshorne |
last post by:
The input to a function of a 3rd party library I want to use requires a
double**, which is a multi-dimension array of doubles.
I have looked on the net etc and seen several ways of supposedly...
|
by: masood.iqbal |
last post by:
All this time I was under the illusion that I understand the concept of
multi-dimensional arrays well ---- however the following code snippet
belies my understanding.
I had assumed all along...
|
by: truckaxle |
last post by:
I am trying to pass a slice from a larger 2-dimensional array to a
function that will work on a smaller region of the array space. The
code below is a distillation of what I am trying to...
|
by: rmorvay |
last post by:
I have a requirement to search a multi-dimensional array for an item, then
delete the item and "reset" the array so that their are no gaps in the
resulting array. I have been trying to figure out...
|
by: Tad Marshall |
last post by:
Hi,
I'm reading about arrays in VB.NET and I seem to have a few options for my
data structure. I need a multi-dimensional array of structures, and my
first thought was
Public Structure myStr...
|
by: nw |
last post by:
Hi,
We've been having a discussion at work and I'm wondering if anyone
here would care to offer an opinion or alternative solution. Aparently
in the C programming HPC community it is common to...
|
by: lovecreatesbea... |
last post by:
Is it always legal to cast expressions of type of multi-dimension
array to type of pointer?
Including:
T to T* ,
T to T* ,
T to T* ,
and so on...
For example:
int *mtxrot1d(int *p,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
|
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...
|
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...
|
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,...
| |