Click here to Skip to main content
15,868,164 members
Please Sign up or sign in to vote.
1.00/5 (4 votes)
See more:
WHILE ACCESSING DATA THROUGH LAN IS VERY SLOW


SELECT MAX(VNO) FROM TABLE


IT IS 25 SECOND TO GET MAX VALUE FROM 25000 RECORD.


ANY SOLUTION?

DATABASE : MSACESS


THANKS
Posted
Comments
[no name] 1-Sep-14 13:28pm    
Why are you still screaming at people?
Mike Meinz 1-Sep-14 14:49pm    
That's why we use SQL Server instead of NS Access for applications with more than a few rows.
Sergey Alexandrovich Kryukov 1-Sep-14 15:43pm    
Do be serious. If you need performance, don't use Access. It cannot even work in the client-server model, forget about anything more advanced.
—SA

Probably Google[^] helps.
 
Share this answer
 
Comments
thatraja 2-Sep-14 3:44am    
5!
CPallini 2-Sep-14 4:00am    
:-)
Two possible reasons that initially come to mind:
- slow connection. Since Access is basically just a "shared file", the connection to the server needs to be fast enough
- no proper indexes. To ensure performance, you should create indexes that satisfy the most common queries. More information, see: CREATE INDEX Statement (Microsoft Access SQL)[^]
 
Share this answer
 
Comments
Sergey Alexandrovich Kryukov 1-Sep-14 15:44pm    
5ed. Actually, using Access in LAN and asking for performance is just ridiculous thing.
—SA
Wendelius 1-Sep-14 23:19pm    
For performance problems you always have this[^] :)
Sergey Alexandrovich Kryukov 1-Sep-14 23:25pm    
Good point... :-)
—SA
thatraja 2-Sep-14 3:44am    
5!
If you are using MS Access database on shared network. Please try below

ASM
1. To Get optimal performance over the network, you should compact and repair your Microsoft Access files on a regular basis.

2. If you are compacting a shared Microsoft Access database that is located on a server or shared folder, make sure that no one else has it open.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900