Expert explanation, said Internet ACCESS more than 100000 records, when the user more than four much, really?
The actual used explain.

CodePudding user response:

No one knows?

CodePudding user response:

Access is generally used in stand-alone program,
Really doing online project (C/S architecture) is not going to do with the Access database, unless it is B/S or multi-layer development,

CodePudding user response:

A lot of problem,

CodePudding user response:

ACCESS for stand-alone version, more tinkering around the edges, the data quantity is too much

CodePudding user response:

Any database would have "limited"

CodePudding user response:

With oracle, ordinary PC, 10 million records are very easy, the latest 11 g enterprise edition can also load on XP,

CodePudding user response:

SQL? The biggest support article how much?

CodePudding user response:

I do is to use the ACCESS database files, share in the local area network (LAN), then the use of DELPHI in front desk, this belongs to the C/S mode, too?
MS SQL Server is how much do you charge for the software? Piracy can use, stable?

CodePudding user response:

Access. Only belong to tinkering around the edges of the product.. You cannot make a big


General small and medium-sized projects, is essentially still can handle it...

The kind of Shared Access only calculate do you said is a stand-alone program... Calculate not C/S
C/S and what kind of data it doesn't matter... Even the Access can do C/S program

Using a computer as a server, for example, put the Access file, and then write a server-side program, as Access database and the client's bridge,,

To write the client, the client by the server program database operation,,, this is the C/S,,,


Sql Server can use free of charge, and specifically how to do that, you know,,

CodePudding user response:

Ok, then will to SQL development, thank you for your advice.

CodePudding user response:

MSSQL charge
A free firebird/mysql/postgresql/sqlite...

CodePudding user response:

Article 100000 to climb the nest

CodePudding user response:

100000 records with Access to estimate a little hard,

CodePudding user response:

The best choice for sqlite,

CodePudding user response:

Sqlite is file type single database,,,,,,,,

CodePudding user response:

Shameless!

CodePudding user response:

With essentially,

CodePudding user response:

mysql

CodePudding user response:

Too access wrong, I just made a network database, access to the student evaluation system, very smooth, collection of database records from 250000 to 300000,

CodePudding user response:

Single use sqlite also is better than the access

CodePudding user response:

Pure kids, if you have the copyright, ok, you can use open source database

CodePudding user response:

Access for small stand-alone CS software or can be, if the data volume of more than 100000, it is best not to use it, the performance is really has a problem, and there are many problems, related queries, issues such as operation is not too insurance,

General small and medium-sized software USES SQL Server 2000 or MySQL can, but the MySQL/MySQL Server has gone away] mistake to let a person have a headache, I feel or SQL2000 work well!

CodePudding user response:

Look at your application level, the number of large amount of data, high concurrency in enterprise database

CodePudding user response:

I suggest to use SQL Server, little thing won't consider Oracle,

CodePudding user response:

Access made several small program, c/s data volume 2-3 w, read no problem, b/s small application program data volume 10 w traverse again super slow, the amount of data, the individual feels more than 10 w or used

CodePudding user response:

Data volume is only one aspect of a assces on Internet use, the biggest problem is, concurrent, locking, and transaction processing!
In SQL SERVER, this should be a complete support, but in ASSCES must you go manual processing, for the amount of data is not a problem, however, if your record field complex, large amount of data, when the big 2 g ASSCESS file, efficiency fell sharply, many errors will appear! So look at your environment!

CodePudding user response:

Postgresql is one of the most powerful, free to and fight orcal, estimates the strength is leverage, but want to install. If you want to green version, use the firebird, sqlite.

CodePudding user response:

A small program that access is suitable for stand-alone version

CodePudding user response:

Before the 100000 play no problem, I didn't use his limit, can not put a lot of article no