SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Improve performance by using SQL Server?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Gyte
Starting Member

Netherlands
23 Posts

Posted - 06/19/2014 :  04:15:46  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3573 Posts

Posted - 06/19/2014 :  08:24:20  Show Profile  Reply with Quote
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

USA
36681 Posts

Posted - 06/19/2014 :  15:14:11  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 06/20/2014 :  09:50:29  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000