It is currently Tue Oct 24, 2017 12:08 am




Post new topic Reply to topic  [ 6 posts ] 
Access database limit 
Author Message

Joined: Sat Nov 08, 2008 9:20 am
Posts: 14
Post Access database limit
Can anyone tell me if the 2Gb limit is still a factor when running on the web using PHP?

Thanks

Tim


Tue Dec 09, 2008 2:46 am
Profile E-mail

Joined: Sun Jan 13, 2008 1:49 am
Posts: 146
Location: Texas, USA
Post Re: Access database limit
The 2G database size limit is what Microsoft wants us believe Access can handle. I have found the DB to misbehave when it gets over 100Mb.

PHP or any other web scripting language have nothing to do with the max size of the DB.

PHP runs best with MySQL. With MySQL the available data storage is the only limit.


Tue Dec 09, 2008 8:49 am
Profile

Joined: Sat Aug 09, 2008 8:48 pm
Posts: 227
Location: China
Post Re: Access database limit
Ugain is so right,

in my experience

LARGE ACCESS DATABASE = TROUBLE

go for MYSQL/SQL

hope it helps

Geno

_________________
DBQWIK-INSITE Resource Center


Tue Dec 09, 2008 10:56 am
Profile E-mail WWW

Joined: Sat Nov 08, 2008 9:20 am
Posts: 14
Post Re: Access database limit
I have a custome application written in MS Access and I have reached the almost 2GB and have had no problems. I was just wandering if I moved to a web based application if I would need to change to MySQL or not. Thanks for your input.

Tim


Thu Dec 11, 2008 4:14 am
Profile E-mail

Joined: Sun Jan 13, 2008 1:49 am
Posts: 146
Location: Texas, USA
Post Re: Access database limit
Tryonce,

It may work well for you as a standalone single user application backend.
However, I have assumed that you wanted to know about running MS Access on the Web in a multi user environment. I am sorry if I have disappointed you, but that is the real world.

I have done a sports products wholesale distribution website that uses Access. It has about 6000 records, text but no OLE. It is approx. 112 MB. It does crash more than I would like.

The same site using Magento eComm (php/MySQL) runs retail, wholesale and product inventory management including all sorts of data reporting. It is about 3x as big. It has not crashed yet. It is also several times faster.

Access_DB grows too quick. Deleted records are not really deleted until you run 'Compact & Repair' on the DB. In MySQL a delete record is truly deleted. It does not require repair (& re-indexing) like Access.


Thu Dec 11, 2008 8:40 am
Profile

Joined: Sat Aug 09, 2008 8:48 pm
Posts: 227
Location: China
Post Re: Access database limit
I too presumed you were talking about a web app.

Geno

_________________
DBQWIK-INSITE Resource Center


Thu Dec 11, 2008 1:34 pm
Profile E-mail WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved