Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gyte
Starting Member
23 Posts |
 Posted - 2014-06-19 : 04:15:46
|
| I am currently developing in VBScript a search facility for file names. At the moment this done by using a text file, in which the names of the files are stored in, separated by carriage returns. In VBScript this text file is being searched in. The text file can contain at least 15000 file names.My question is:- Is it better to use a database system to store the file names in?- If so, will this speed up the searching?- If so, which database would be the best choice for this simple task? MS Access or MS SQL Server? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-06-19 : 08:24:20
|
quote:
Originally posted by Gyte
I am currently developing in VBScript a search facility for file names. At the moment this done by using a text file, in which the names of the files are stored in, separated by carriage returns. In VBScript this text file is being searched in. The text file can contain at least 15000 file names.My question is:- Is it better to use a database system to store the file names in?- If so, will this speed up the searching?- If so, which database would be the best choice for this simple task? MS Access or MS SQL Server?
When you have a hammer, everything looks like a nail. And everyone on this forum has a hammer. With that caveat, answers to your questions:a) In most cases it is better to store the data in a database.b) Yes it can speed up searching, especially so when the number of names you want to search is large.c) If this is your only task MS Access or SQL Server would work. SQL Server has free editions (SQL Express), but if I am not mistaken, MS Access does not. That might be a consideration. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-19 : 15:14:11
|
| I don't think I'd select Access for any project. I have zero experience with Access, but it seems to me that those that are using it are newbies to programming, reporting and/or databases. I don't think I'd select Access for a project where the "application" will be in VBScript.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-20 : 09:50:29
|
| How many people will be using this facility? Will it be web-based application , or an internal process?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
Improve performance by using SQL Server?