Sql server performance and MS Access

Question

I have an existing application that uses Sql Server 2005 as a background. It contains huge records, I need to combine tables that contain 50K-70K. The m / c client is lower equipment.

So, can I improve performance using MS Access as source code? I also need to search the Access file. So which one is better for performance?

Is an access query better than an SQL query in lower h / w?

Answer 1

Because SQL Server runs as a separate process, caches the results, uses ram and processing power when not requested, etc., IF the other computer has very little RAM or a very slow processor (or perhaps even more important one -core) , I could see a situation where SQL Server is actually SLOWER than using MS Access.

Without information on setting up your equipment, approximately what percentage of your application depends on database queries, etc., I'm not sure that this question can be easily answered.

MS SQL Server 2005 Express requires at least 512 MB of RAM (see http://www.microsoft.com/sqlserver/2005/en/us/system-requirements.aspx ), therefore, if your lower-level equipment does not work, they have both 512 MB minimum, I would of course choose MS Access through SQL Server.

, SQLite (. http://www.sqlite.org/), , MS SQL Server. , MS Access - Jet. , .

Answer 2

70 000 SQL- ( ). , , , , SQL-, Access.

, , , , , .

SQL- . // , , , .

Answer 3

, , , , ( Access SQL Server, , ), , Access Jet/ACE . SQL Server , , SQL Server .

, , . Access SQL Server ( ), , , , Jet/ACE .

, . .

Answer 4

SQL Server Express 2005 VS MS Access 2010, , SQL Server , MS Access ( ). , , , MS Access , SQL Server ( , Access SQL Server).

, , .

Answer 5

, Access SQL.

, , 10K Access, SQL, . , 4, 2 . , . , . - / . 2 , Microsoft SQL Server 2014 Express Edition 10 . SQL Express - SQL, . SQL Server 2014 524PB (524,000,000GB). , .

10 . 100 . , SQL .

MS Access " ", , SQL- .

? , . Access, " ", , , , . , SQL- , SQL .

, (< 10K ) , 4 , MS Access . , 10 . 5 , SQL .

, 50 -70K . , , , SQL , (, SQL-), Access .

Answer 6

SQL Server Express 2014 1 2200 (2200x 1 )

SQL Server Express 2014 ( IP) 1 2200 (2200x 1 )

SQL Server 2000 ( ) 1 10000 (10000x 1 )

1 55000 (55000x 1 )

.

Answer 7

, 18- . /// . .

70 . . , , SQL-, Windows 70 . . , -, - db, Access .

Answer 8

SQL Server , . , , .

Answer 9

SQL Server has the best indexing options ... Filtered indexes, included columns, etc. There is a possibility of ZERO that an Access query is faster than a properly programmed SQL Server database query.