Solved General Advice for Multi User Split DB (1 Viewer)

[Kha]

Hi,
I feel that my database is performing slowly, are there advice or settings to improve the performance of my database (split database)?

 

[June7]

Depends what is causing slow performance - network, server, data structure, queries, file size?

 

[Kha]

Depends what is causing slow performance - network, server, data structure, queries, file size?

Size 30 MB
General Advice please

 

[theDBguy]

Are you using a persistent connection?

 

[Kha]

Are you using a persistent connection?

Wire LAN

 

[theDBguy]

Wire LAN

Sorry, can't give you a link right now but try searching for those terms.

Sent from phone...

 

[CJ_London]

take a look at these threads

addressing performance issues

As your db expands and there are more active users, it is quite possible you will experience performance issues and may be considering upsizing to SQL Server or MySQL. Before considering such a transition, you should review your current design: Overview From a performance perspective, Access...

www.access-programmers.co.uk

Why indexing is important for good performance

Indexing is essential for the efficient retrieval of data from a db. Some may be concerned about the additional disk space required for the index(es) - but disk space is cheap and they do not take up that much space. For small db's - a few '000 records per table and simple queries it is...

www.access-programmers.co.uk

There may be something you can do that you are not doing at the moment.

 

[GPGeorge]

Wire LAN

Since theDBGuy appears to be unavailable at the moment, let me offer some info on the subject of persistent connections.

Your front end periodically reaches out to the back end to retrieve data or update data. Each time it does that, it first has to make sure there is a connection between them. If not, it has to start one. That is often a cause for slow performance in a split relational database application.

The way many savvy developers deal with that is that they never let the connection between them drop. How? They open a small, hidden form which is bound to one table in the back end and leave it open. That maintains the connection, i.e. makes it persistent. And that usually improves performance noticeably.

 

[Isaac]

I'm not on board with the idea of demanding "general advice". A problem is something to troubleshoot for the purpose of narrowing it - that's the whole point of being a trouble-shooter. You need to identify and isolate one specific slow thing or function, and then troubleshoot it - and ask for advice on that.

At that point, you may have epiphanies and learning experiences that you can generalize outward, but trying to do the reverse is not generally the way to approach programming and tuning and specifically the interplay between your own program vs. advice from the community.

 

[Pat Hartman]

What is the BE? Is it Jet/ACE or some RDBMS?

 

[MajP]

Hello everyone, what's happening? So my car is not running well. I do not have the time, energy, or interest in providing you any details. Researching this on Google seemed a lot of work. Yeahhh..., so if you can spend your time providing me everything I need, that would be Great. Thanks.

 

[Pat Hartman]

@Kha You are very new here and we're happy to have you. I appreciate the like but we are not children here. You don't need you to "like" our questions. You will have a far better experience if you simply answer questions so we can give you more targeted answers. Then report back on suggestions that actually worked. Simply "liking" everything is totally useless.

 

[Kha]

@Kha You are very new here and we're happy to have you. I appreciate the like but we are not children here. You don't need you to "like" our questions. You will have a far better experience if you simply answer questions so we can give you more targeted answers. Then report back on suggestions that actually worked. Simply "liking" everything is totally useless.

you are right
I apologize

 

[Isaac]

Hello everyone, what's happening? So my car is not running well. I do not have the time, energy, or interest in providing you any details. Researching this on Google seemed a lot of work. Yeahhh..., so if you can spend your time providing me everything I need, that would be Great. Thanks.

the way that guy talks reminds me of beavis and butthead's high school teacher

 

[MajP]

the way that guy talks reminds me of beavis and butthead's high school teacher

That is a very astute observation. Beavis' and Butthead teacher, Mr. David Van Driessen, is voiced by Mike Judge. Mike Judge is the shows creator. Also happens to be the writer and Director of Office Space. Gary Cole who plays Lundbergh also voiced in Beavis and Butt-Head, so there is a link.

 

[gemma-the-husky]

That is a very astute observation. Beavis' and Butthead teacher, Mr. David Van Driessen, is voiced by Mike Judge. Mike Drudge is the shows creator. Also happens to be the writer and Director of Office Space. Gary Cole who plays Lundbergh also voiced in Beavis and Butt-Head, so there is a link.

But Mike Judge also made King of the Hill. I'm sure that's what real America does. The boy ain't right.