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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Improve performance by using SQL Server?

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.
Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -