Mike
|
| Posted: 03/14/2002, 6:31 AM |
|
My Question is MaAccess reliable as web database i mean this connection :
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=c:\db\database.mdb;Persist Security Info=False"
is this connection stable in multi user connections to the database.
thanks
|
|
|
 |
Gene
|
| Posted: 03/14/2002, 7:11 AM |
|
Mike,
MS Access is fine for about 10-15 users who are updating tables. It will
max out at around 20 users. If users are only reading from the table and the
table is set to readonly, then these limits are significantly higher.
Gene
|
|
|
|
Sam M
|
| Posted: 03/15/2002, 11:48 AM |
|
I've gotten access 2000 to handle 200 simaltanious inserts.
Never been able to go over that. Also recently discovered that There is a limit of 68000 records in access. Word to the wize, if you're working with web stats on any level, use some other relational database format. My second choice, foxpro. Doesn't do autonumber, but it handles more users than access, and tends to be more stable. Just a though.
Laters
Sam
|
|
|
|
Ron Borkent
|
| Posted: 03/16/2002, 6:04 AM |
|
If you want to do serious work with a lot of users I'd go for MySql. I've got it running on win2k and Linux for the company intranet and it is used by 400 + employees. It hasn't failed me yet.
I find that MySql is stable, scalabel and has most of the features I need. The alternative was the company database that runs on Oracle 8. I've tried that but is is to slow. Oracle has great features but that diectly impacts the speed. I still work with oracle for management info via the intranet but I tend to use it as little as possible.
|
|
|
|
Mike
|
| Posted: 03/16/2002, 6:28 AM |
|
Yes That's right mysql is the best database but i have many problems with the connection to this database using ASP , Can you tell me the best setting to connect to mysql database Please
|
|
|
|
Brent
|
| Posted: 03/16/2002, 1:42 PM |
|
>>Yes That's right mysql is the best database but i have many problems with the connection to
>>this database using ASP , Can you tell me the best setting to connect to mysql database
Mike,
You do not need Persistent connections if using MySQL. It connects quite
fast so you're not gaining anything with persistent connections besides
eating up a lot of memory.
Brent
|
|
|
|
Sam M
|
| Posted: 03/19/2002, 8:50 AM |
|
When I choose a database format, I ask myself the following questions:
1. How hard is it to use?
2. Will it randomly shut itself off when the user load is too high?
3. Does it have feautres like file locking?
4. Is there a big enough user base of people using it?
5. Will it connect through ODBC?
When asking myself these questions, two databases come to mind.
1. SQL server
2. Oracle
MySQL is a good freeware database format, but as with anything, you get what you pay for. I think foxpro/dbase are easy to use and a robust alternative to access, but I have found that I'm pretty much alone in that preference.
I recomend SQL server because it's just a better database format. Dollars to donuts, it's just better technology.
If you're serious about developing databases, that's the one I would go with because:
1. It's got good security over all.
2. It's generally affordable to host these days
3. There is a large group of people using it. I find that when there is a larger user base, it's easier to solve problems.
4. It doesn't take six hours to cinfigure like MySQL, Sybase, and some of the other database varients on the market today.
|
|
|
|
|
