473,320 Members | 1,823 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Text file vs DB

Hi all,

I am designing an app to run on Windows Mobile 5 using VB.NET 2005. The
app will make use of a couple of static tables for reading data and 1 table
of data which the user will modify. Currently I am trying to decide how
best to store the data.

I saw that Microsoft has released a CTP of SQL Everywhere which they say
is perfect for mobile devices. It looks really good and I immediately decided
to use it. Then, I had a bit of think about it and now I am not so sure.
My DB will have around 4-5 tables with no more than 1000 records in 1 of
the tables and the other tables being much smaller. My app runs, loads the
big table into an array (Would I benefit from using SQL and not loading the
array into memory?) and then works on it. So, does anyone know if I would
benefit from using the SQL database or if I'd be better off sticking with
simple text files/XML files to store my data? I want to choose the fastest
solution, not the most elegant nor the one that requires the least code.
My biggest concern is speed of data access and also size of DB's.

The app does simple text searching and storage of text values from a reference
DB, nothing complicated with the database.

TIA
Daniel
---------------------------------------------------
To contact me you need to clean up my email address. It should be fairly
obvious...
Oct 25 '06 #1
2 1134
Hi,
>>
My app runs, loads the
big table into an array (Would I benefit from using SQL and not loading the
array into memory?)
<<

I think this is one of those, "It depends, answers." However, my best guess
is that it would be easiest to simply leave it in the ResultSet that you
created when you load the table. I'd use an array or collection (or other
list) only if the data was used to populate an object that has more complex
behavior.
>>
So, does anyone know if I would
benefit from using the SQL database or if I'd be better off sticking with
simple text files/XML files to store my data? I want to choose the fastest
solution,
<<

SQL will be easiest to use and expand. Fastest? Maybe, maybe not...
Reading a XML file may be fastest. Updating the XML (which will require
re-writing the entire file) may be slower. I don't think there is a simple
answer.

Dick

--
Richard Grier, MVP
Hard & Software
Author of Visual Basic Programmer's Guide to Serial Communications, Fourth
Edition,
ISBN 1-890422-28-2 (391 pages, includes CD-ROM). July 2004, Revised March
2006.
See www.hardandsoftware.net for details and contact information.
Oct 25 '06 #2
Hi,
>
My app runs, loads the
big table into an array (Would I benefit from using SQL and not
loading the
array into memory?)
<<
I think this is one of those, "It depends, answers." However, my best
guess is that it would be easiest to simply leave it in the ResultSet
that you created when you load the table. I'd use an array or
collection (or other list) only if the data was used to populate an
object that has more complex behavior.

So, does anyone know if I would
benefit from using the SQL database or if I'd be better off sticking
with
simple text files/XML files to store my data? I want to choose the
fastest
solution,
<<
SQL will be easiest to use and expand. Fastest? Maybe, maybe not...
Reading a XML file may be fastest. Updating the XML (which will
require re-writing the entire file) may be slower. I don't think
there is a simple answer.

Dick
Thanks Dick.

Daniel
---------------------------------------------------
To contact me you need to clean up my email address. It should be fairly
obvious...
Oct 26 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
by: Ling Lee | last post by:
Hi all. I'm trying to write a program that: 1) Ask me what file I want to count number of lines in, and then counts the lines and writes the answear out. 2) I made the first part like this: ...
1
by: Rigga | last post by:
Hi, I am new to Python and need to parse a text file and cut parts out i.e. say the text file contained 5 rows of text: line 1 of the text file line 2 of the text file line 3 of the text...
27
by: Eric | last post by:
Assume that disk space is not an issue (the files will be small < 5k in general for the purpose of storing preferences) Assume that transportation to another OS may never occur. Are there...
16
by: thenightfly | last post by:
Ok, I know all about how binary numbers translate into text characters. My question is what exactly IS a text character? Is it a bitmap?
7
by: Chris | last post by:
Hi I can use a text file as a datasource but am unable to get the datatable to see the text file as having multiple columns. Everything gets put into the first column in the datatable. Sample of...
3
by: bbepristis | last post by:
Hey all I have this code that reads from one text file writes to another unless im on a certian line then it writes the new data however it only seems to do about 40 lines then quits and I cant...
1
by: Osoccer | last post by:
...to a different folder and in the relocated file concatenates all of the lines in one long string with a space between each line element. Here is a fuller statement of the problem: I need a...
10
by: bluemountain | last post by:
Hi there, Iam new to python forms and programming too I had a text file where i need to extract few words of data from the header(which is of 3 lines) and search for the keyword TEXT1, TEXT2,...
0
Debadatta Mishra
by: Debadatta Mishra | last post by:
Introduction In this article I will provide you an approach to manipulate an image file. This article gives you an insight into some tricks in java so that you can conceal sensitive information...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.