Re: Cannot open Access table with ADO or BDE/ODBC

Doug Stephens wrote:


280,000 records No blobs. Not tried with server side cursor.
Not even really sure what that is:) But there is no "server" in this
scenario, unless you call JET a server.

wow, I also think the problem lies in the number of records. As Vitali
points out your system will try to fetch them all in memory.

Desktop databases do such things, in opposition to RDBMS, because they
are designed for small databases and can usually (but not always)
afford to fetch all the data.

--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Re: Very Newbie FTP questions
    ... Saved in HTML. ... >> Fetch, connected with my new web site. ... > I'm assuming that you were able to connect with your server since you ... to force a page reload in the browser (unless you have your browser ...
    (comp.sys.mac.comm)
  • Re: Table Defaults
    ... This following definition is from Microsoft ... Fetch Defaults Choose Yes to have the form fetch the default ... It appears you assume FetchDefaults prevents the server call. ... For some tables it actually inhibits / interferes with the user entry. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: [fw-wiz] i-cap proposals
    ... POP3 is the insane mail protocol. ... You really should be doing scanning on the server. ... If you trigger a scan on a header fetch, ...
    (Firewall-Wizards)
  • Re: Swing performance query
    ... Martin Gregorie wrote: ... fetch a block of data from the server ... This shows that, provided the average fetch is more than 25 bytes or so, the transfer rate across a 10Mb/s sockets connection is at least as fast as the data rate on a 9600 baud serial connection. ... What about the display operation that I thought was slow? ...
    (comp.lang.java.programmer)
  • Re: Fetchmail revisited
    ... I want it to fetch for all users and forward to the stmp server without ... modifying them. ... All mail to mydomain is put into one mailbox at my isp. ...
    (alt.os.linux.suse)