/    Sign up×
Community /Pin to ProfileBookmark

Maximizing speed with access database

Copy linkTweet thisAlerts:
Dec 29.2009

I have a website that uses an Access database to pull information for the site.

I am in the process of translating the website into many languages so as to maximize the traffic potential.

Currently I have English and Spanish and will soon be expanding to other languages.

The database has 1 set of data for each language, each stored in seperate tables in the same Access database. I.e. 1 table for Spanish and 1 table for English.

I was wondering if it would speed up the database connections if I were to have seperate databases for each language. i.e. a seperate Access database for Spanish, English, French, etc.

That way when people in France are performing a query, it will be coming from a different Access database and would not interfere with the connection speeds of the people performing queries in the USA (on the English database).

In this scenario all of the Access databases would be stored in the same directory on the host.

Or would this not make any difference to the connection speeds? Seeing as it is all one website on the same host.

FYI, I do not want to spend additional funds on the hosting of an SQL Server database.

to post a comment
Full-stack Developer

4 Comments(s) ↴

Copy linkTweet thisAlerts:
@ryanbutlerDec 29.2009 — Access is the problem, it isn't meant for what you're trying to do. Much beyond 100 + records on the web, it chokes. Does your host support MySQL (it's a free db engine)? If so, I check that approach.

If not, you'll probably have to live with slightly less than desired performance.
Copy linkTweet thisAlerts:
@TonyLoco23authorDec 29.2009 — Actually, MS Access is handling the load quite fine. My question was about maximizing the ability of Access, just in case it starts to have problems when more users in other countries begin to use the site more.

My hosting company charges a lot of money to run SQL Server and MySQL databases, it something like $100 per quarter, which is way too much, especially when Access seems to be doing fine at the moment.

If I am going to need seperate tables for each language, then I figured why not store them in seperate databases if that will help boost performance? But if it will not improve performance then I will just keep all the tables in a single Access database.
Copy linkTweet thisAlerts:
@ryanbutlerDec 30.2009 — Actually, MS Access is handling the load quite fine. My question was about maximizing the ability of Access, just in case it starts to have problems when more users in other countries begin to use the site more. [/quote]

That will become an issue. The more tables you add and the more record you add, it simply won't scale, made that mistake years ago.

My hosting company charges a lot of money to run SQL Server and MySQL databases, it something like $100 per quarter, which is way too much, especially when Access seems to be doing fine at the moment.[/quote]

They charge you for MySQL? How are they doing that when it doesn't cost them a dime? That doesn't seem right to me and to me it borders on ethics and legal issues since that's a widely known open source database solution. I'd look into a more efficient hosting provider. Mine is Softsys. Often times the additional cost is worth the hassle of frustrated customers.

If I am going to need seperate tables for each language, then I figured why not store them in seperate databases if that will help boost performance? But if it will not improve performance then I will just keep all the tables in a single Access database.[/QUOTE]

Either way it's going to degrade over time, trust me.
Copy linkTweet thisAlerts:
@jonmasterDec 30.2009 — There are tons of good quality hosting services for cheaper price,

$100 per quarter, OMG, that to without sql and mysql... You are ripped.

YOu could rent a vps for that price.

softsyshosting.com is a good place,

aplus.net and many more do a search.

And the answer for your main question.

Yes Creating a New database seperately for spanish will minimize the load.

if the site just retrieves record from the access database, no frequent updating , deleting, then it can hold even 2000+ records per table and couple of tables like that.

But if multiple users accesses the site for editing then it will be a question.

I have developed site with access database with over 3000 records and still works fine managing 1000 users perday.(really surprising for me though many said access cannot withstand that much traffic)

Occassionaly you can compact your database to reduce its size, that will improve the performance substantially.

cheers
×

Success!

Help @TonyLoco23 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.19,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...