|
|
| |
Extra Web Hosting
Services - Gconnect -
The Business ISP |
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
MS SQL Access |
|
|
|
|
£POA |
|
|
 |
|
|
| |
By far
the most common database application on an NT
hosted server is Microsoft Access 2000. However it
actually falls into the 'desktop' category of
database which is best for individuals and small
companies managing only megabytes of data.
It's maximum capacity for concurrent users
(simultaneous connections) is 255 - ok if you're
using it locally in your office but when
integrated within a website this number is
dramatically reduced to approximately 25
concurrent users.
This number is not the amount of people visiting and
browsing around the website at one time but the
number of physical connections requesting/writing
data to the database at any one time.
If your website is likely to generate many
database calls not only from users selecting to
update records/ retrieve information, but also
from web pages loading to generate dynamic
database content or validate users in specific
areas, or you anticipate the traffic to your
website growing quickly, you should seriously
consider hosting your database on MS SQL Server
2000.
The following comparison chart shows how great the
benefits of SQL Server actually are. Concurrency issues are
virtually eliminated as maximum concurrency is
determined only by memory/space available. In many
instances a SQL Server application may actually be
distributed over several physical servers.
|
|
Feature
Comparison - MS SQL Server 2000 vs MS Access
2000 |
|
|
|
|
|
|
|
Feature |
SQL Server 2000 |
Access 2000 |
| database size
|
1,048,516 TB
|
2 GB plus linked tables
size |
| objects in a database
|
2,147,483,647
|
32,768 |
| user name length
|
128 |
20 |
| password length
|
128 |
14 |
| table name length
|
128 |
64 |
| column name length
|
128 |
64 |
| index name length
|
128 |
64 |
| Number of concurrent
users |
limited by available
memory |
255 |
| columns per table
|
1024 |
255 |
| table size
|
limited by available
storage |
1 GB |
| number of indexes in a
table |
250 |
32 |
| number of columns in an
index |
16 |
10 |
| bytes per row
|
8060 |
2000 |
| number of tables in a
query |
256 |
32 |
| columns per SELECT
statement |
4096 |
255 |
| nested sub-queries
|
32 |
50 |
| number of enforced relationships |
253 |
32 |
| SQL statement size |
65,536 * Network packet size (4 KB, by default) |
approximately 64,000
|
| SMP support |
Supported |
Not Supported |
| Tables |
Relational tables,Temporary tables |
Relational tables |
| Triggers |
AFTER triggers, INSTEAD OF triggers |
Not Supported |
| Procedures |
Microsoft T-SQL statements |
Not Supported |
| User-defined functions |
Scalar functions, Inline table-valued functions, Multi-statement table-valued functions |
Not Supported |
| Views |
Supported |
Not Supported |
| Transaction logging |
Supported |
Not Supported |
| Recovery |
Recovery to last backup, recovery to the point of failure, recovery to a specific point in time |
Recovery to last backup |
| Integration with Windows NT security |
Supported |
NOT Supported |
|
|
|
Forward planning is key to managing your
databases. If you a unsure of which method to
implement why not develop your website using
Access and plan to 'upsize' the database at a
later date.
So what is Upsizing?
This is the method of converting your Access
database to MS SQL Server. We can help with both
planning and performing this task for you.
Are there any scripting implications which need to
be considered?
Short answer - yes. But not too many, most
developers will be aware of the differences when
querying the database with certain SQL commands.
Unlike Microsoft Access where you actually
download the database to work on it and then
re-upload it, SQL Server 2000 is accessed via
Microsoft's Enterprise Manager tool.
This enables you to work with the live data with
little overhead on your connection's bandwidth.
Sample of the enterprise manager interface:
Once your database has been created, and depending on the
security level of your account, it is possible to
control all aspects of your database. Adding,
editing and deleting tables and fields, importing
and exporting data
to/from almost any
other type database
and even recreating
the entire database
from an alternate
installation.
When transferring to
Gconnect's web
hosting services
many of our
clients supplied their most
recent SQL Server
database for
recreation. This
includes both
structure and data.
To discuss SQL
Server hosting for
your current, or
planned, website
please call 0845 006
0866 or email
sales@gconnect.net
|
|
|
|
|
|
|
|
|
|
|
|
