Click here to Skip to main content
15,914,943 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionOpen a file from Local disk Pin
recono112-Nov-07 12:22
recono112-Nov-07 12:22 
AnswerRe: Open a file from Local disk Pin
Luc Pattyn12-Nov-07 14:54
sitebuilderLuc Pattyn12-Nov-07 14:54 
AnswerRe: Open a file from Local disk Pin
Baddog_52017-Nov-07 16:43
Baddog_52017-Nov-07 16:43 
QuestionFaxing from word.doc from VB Pin
simonk196912-Nov-07 11:59
simonk196912-Nov-07 11:59 
QuestionDatagrid Hyperlink column Pin
Num1CodeStudent12-Nov-07 8:59
Num1CodeStudent12-Nov-07 8:59 
QuestionMake any sense? Pin
cstrader23212-Nov-07 5:06
cstrader23212-Nov-07 5:06 
AnswerRe: Make any sense? Pin
Paul Conrad28-Nov-07 15:14
professionalPaul Conrad28-Nov-07 15:14 
GeneralRe: Make any sense? Pin
cstrader23228-Nov-07 17:14
cstrader23228-Nov-07 17:14 
Hi. Thanks for your reply. Here's the postcard version, as expanded from the sticky.

This is not so much an issue of can I do it? but can I do it fast?

I have data on several thousand stocks which are downloaded every day. They are persisted on the disk in some format, each in its own file (several thousand files). Each file has a matrix of some string and some double and some integer values. The matrix is say 500 rows by 10 columns in each file, each row representing one date.

I need to, for each file

1. Open and read the matrix
2. Sort the matrix by date and select the dates I want
3. Calculate new values in new columns (say a moving average or a sum or difference)
4. Output the result
5. Close and move to the next file

My benchmark is c++ programs that seem to be able to do this really, really fast.

So what format should I store the files in?
Text? (small, but need to be read line by line)
Xml? (much bigger, but can be read into a dataset in one XMLread)
Serialized object array? (maybe, but how to filter the data by date?)
Data structure?
Other?

My strategy has been to
1. Store as XML datatable and read from that datatable
2. Create a dataviewer to sort and filter
3. Perform my calculations on the datagridview created from the dataview

This works, but I need to go faster. Would a data structure be appropriate? I could serialize an object array, but then how to filter it by date? SQL or ODBC didn’t seem like they would be useful.

Thanks again



GeneralRe: Make any sense? Pin
Paul Conrad28-Nov-07 17:36
professionalPaul Conrad28-Nov-07 17:36 
GeneralRe: Make any sense? Pin
cstrader23229-Nov-07 3:31
cstrader23229-Nov-07 3:31 
QuestionMessageBox Pin
Abbhie12-Nov-07 4:20
Abbhie12-Nov-07 4:20 
AnswerRe: MessageBox Pin
Luc Pattyn12-Nov-07 4:31
sitebuilderLuc Pattyn12-Nov-07 4:31 
AnswerRe: MessageBox Pin
Paul Conrad12-Nov-07 4:36
professionalPaul Conrad12-Nov-07 4:36 
AnswerRe: MessageBox Pin
Vimalsoft(Pty) Ltd12-Nov-07 5:46
professionalVimalsoft(Pty) Ltd12-Nov-07 5:46 
QuestionHow to create a Wi-Fi Manager? Pin
Paramhans Dubey12-Nov-07 1:42
professionalParamhans Dubey12-Nov-07 1:42 
AnswerRe: How to create a Wi-Fi Manager? Pin
DigiOz Multimedia12-Nov-07 5:30
DigiOz Multimedia12-Nov-07 5:30 
AnswerRe: How to create a Wi-Fi Manager? Pin
mykingdomforanewusername12-Nov-07 12:54
mykingdomforanewusername12-Nov-07 12:54 
GeneralRe: How to create a Wi-Fi Manager? Pin
Paramhans Dubey13-Nov-07 1:52
professionalParamhans Dubey13-Nov-07 1:52 
AnswerRe: How to create a Wi-Fi Manager? Pin
Baddog_52017-Nov-07 16:58
Baddog_52017-Nov-07 16:58 
Questionmultiple String Table. Pin
birajendu12-Nov-07 1:21
birajendu12-Nov-07 1:21 
Questionhow to make xml comments in vb.net Pin
codeproject_buna12-Nov-07 1:01
codeproject_buna12-Nov-07 1:01 
AnswerRe: how to make xml comments in vb.net Pin
Steven J Jowett12-Nov-07 1:08
Steven J Jowett12-Nov-07 1:08 
AnswerRe: how to make xml comments in vb.net Pin
Cameron Marsden12-Nov-07 1:11
Cameron Marsden12-Nov-07 1:11 
AnswerRe: how to make xml comments in vb.net Pin
AliAmjad12-Nov-07 1:21
AliAmjad12-Nov-07 1:21 
AnswerRe: how to make xml comments in vb.net Pin
John_Adams14-Nov-07 10:15
John_Adams14-Nov-07 10:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.