Website Development / Intranet Application Development
Some points you need to think about
MS SQL or Access?
Below is a small comparison between Access and SQL. Most often selection is done considering non-technical factors like cost, maintenance etc. and technical factors like stability, security etc. Our analyst team will suggest to you whatever is suitable for your project.
Microsoft Access is a full-featured multi-user relational database management system that is designed for the Microsoft Windows Operating Systems.
Some General Access 97/2000 characteristics:
| Object |
Maximum sizes/numbers |
| Database size |
1 Gb |
| Number of characters in an object name |
64 |
| Number of characters in a password |
14 |
| Number of characters in a user name or group name |
20 |
| Number of concurrent users |
255 |
| Number of characters in a table name |
64 |
| Number of characters in a field name |
64 |
| Number of fields in a table |
255 |
| Number of characters in a Text field |
255 |
| Number of characters in a Memo field |
65,535 / 1 Gb |
There are general SQL Server 97/2000 characteristics:
| Object |
Maximum sizes/numbers |
| Batch size |
65,536 * Network Packet Size |
| Bytes per short string column |
8,000 |
| Bytes per text, ntext,or image column |
2 GB-2 |
| Bytes per index |
900 |
| Bytes per foreign key |
900 |
| Bytes per primary key |
900 |
| Bytes per row |
8,060 |
| Bytes in source text of a stored procedure |
Lesser of batch size or 250 MB |
| Clustered indexes per table |
1 |
| Columns per index |
16 |
| Columns per foreign key |
16 |
| Columns per primary key |
16 |
| Columns per base table |
1,024 |
| Columns per SELECT statement |
4,096 |
| Columns per INSERT statement |
1,024 |
| Connections per client |
Maximum value of configured connections |
| Database size |
1,048,516 TB |
| Databases per instance of SQL Server |
32,767 |
| Filegroups per database |
256 |
| Files per database |
32,767 |
| File size (data) |
32 TB |
| Identifier length (in characters) |
128 |
| Locks per connection |
Max. locks per server |
| Nested stored procedure levels |
32 |
| Nested subqueries |
32 |
| Nested trigger levels |
32 |
| Nonclustered indexes per table |
249 |
| Objects in a database |
2,147,483,6474 |
| Parameters per stored procedure |
1,024 |
| REFERENCES per table |
253 |
| Rows per table |
Limited by available storage |
| Tables per database |
Limited by number of objects in a database |
| Tables per SELECT statement |
256 |
| Triggers per table |
Limited by number of objects in a database |
| UNIQUE indexes or constraints per table |
249 nonclustered and 1 clustered |
PHP OR ASP?
The IT world is still debating over it! Believe it or not many companies select either one of these without even analyzing their requirement. Most of the time its left to an individual's personal liking!
We do not believe in decisions made without proper reasons to support it. "This is what my neighbor uses" is never going to be the reason behind taking a decision in selecting a language for your web development.
We analyze various aspects like cost, speed, database handling, base language, internet server etc. before recommending clients for a specific language and server.
|
