NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Upload - to database, or not to database?
2551
Upload - to database, or not to database?
http://upload-to-database-or-file.pstruh.cz/help/scptutl/pa28.htm
To database or not to database? What to do with uploaded files on server-side? This article contains performance tests of several store-file methods in server-side ASP.
We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command ASP > Tips and Tutorials > Database-related Oct 10, 2006
We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command ASP > Tips and Tutorials > Database-related Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Upload - to database, or not to database?: |
|||
Other links at ASP > Tips and Tutorials > Database-related
This is a topic I've seen covered by others in the past but never in enough detail to satisfy me. This technique is extremely powerful and can yield huge performance gains over non-cached queries and therefore deserves more attention.
Category:
The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. The first article in this series entitled "Using the SQL Distributed Management Objects", provided an overview of SQL-DMO. This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.
Category:
SQL Server 7.0 - installed on a server. This can be either a Windows NT 4 or Windows 2000 Server system. For help on seting up SQL Server, click HERE.
Configure SQL Server to use SQL Server and Windows NT authentication:
Open the SQL Server Enterprise Manager.
Right-click on the SQL Server which will be used with your ASP pages.
Click on Properties.
Click on the Security tab.
In the Authentication: section, click on SQL Server and Windows NT.
Click on the OK button to finish.
Internet Information Server 4.0 (IIS4) - installed on a Windows NT 4 Server.
ADO 2.0 (or later) - installed on the same server as the IIS4 computer. ADO comes as part of Microsoft's MDAC components
Configure SQL Server to use SQL Server and Windows NT authentication:
Open the SQL Server Enterprise Manager.
Right-click on the SQL Server which will be used with your ASP pages.
Click on Properties.
Click on the Security tab.
In the Authentication: section, click on SQL Server and Windows NT.
Click on the OK button to finish.
Internet Information Server 4.0 (IIS4) - installed on a Windows NT 4 Server.
ADO 2.0 (or later) - installed on the same server as the IIS4 computer. ADO comes as part of Microsoft's MDAC components
Category:
ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. I will show you how to do it two ways: in the global.asa and in any ASP page.
Category:
In Active Server Pages, all strings are enclosed in double quotes ("). For example, if you wanted to pull in all orders from the database, the SQL string would look like this:
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19539
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 228079
Pagerank Statistics
PHP News