Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Size and concurrency limits on Jet 4.0 dB engine?

Reply
Thread Tools

Size and concurrency limits on Jet 4.0 dB engine?

 
 
Joe Van Meer
Guest
Posts: n/a
 
      05-05-2004
Hi there,

I hear access has a limit of 10-15 concurrent users...although I have never
run into probs.

Cheers, Joe


"Charlie@CBFC" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hi:
>
> I have chosen to use Jet 4.0 db engine on an e-commerce site because

client
> wants to save on hosting costs and doesn't expect a lot of traffic. In

the
> past I have always used SQL Server and FoxPro without problems.
>
> What are the size and concurrency limits on Jet dB engine? When is it time
> to upgrade to SQL Server? Is there any documentation on this?
>
> Thanks,
> Charlie
>
>



 
Reply With Quote
 
 
 
 
Charlie@CBFC
Guest
Posts: n/a
 
      05-05-2004
Hi:

I have chosen to use Jet 4.0 db engine on an e-commerce site because client
wants to save on hosting costs and doesn't expect a lot of traffic. In the
past I have always used SQL Server and FoxPro without problems.

What are the size and concurrency limits on Jet dB engine? When is it time
to upgrade to SQL Server? Is there any documentation on this?

Thanks,
Charlie


 
Reply With Quote
 
 
 
 
Peter O'Reilly
Guest
Posts: n/a
 
      05-05-2004
From my experience..
a 2GB documented file size limitation although the database will start to go
haywire long before it reaches that size. About 9,10 "writeable"
(insert/update/deletes) concurrent connections and 30+ "read only"
connections (executing select SQL statements). Performance degrades quite a
bit after 20 readable connections.

Other considerations...

Be sure to have the mdb file located on the same box as the webserver
otherwise performance goes out the window.

Access 97 (Jet 3.5x) is preunicode. Later versions - the file size will be
roughly double.

SQL Server databases security is much better (Jet may be adequate though)
and is less prone to becoming corrupt.

Hope this helps.

Good luck.
--
Peter O'Reilly


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Control of Priority Queue Order? And size limits on queues? Mason Kelsey Ruby 5 10-02-2009 06:02 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM
Re: J2ME jar size limits Andreas Rueckert Java 2 08-04-2003 08:44 PM



Advertisments