Article View: borland.public.cppbuilder.database.ado
Article #1149VFP OLEDB slow
From: Orlando Lopez
Date: Tue, 05 Oct 2004 18:56
Date: Tue, 05 Oct 2004 18:56
19 lines
1595 bytes
1595 bytes
Hi to all, I don't know if somebody here try to use VFPOLDB, but, I have 2 simple tables (.dbf files) and I have 2 process 1 process write to 1 table and wait for the another process response, reading in the another table. That is very simple, this 2 table don't have index. But the process that wait for the response is very slow (5 seg for process each record). I do a test using VFP 6, and using it this process is very quick (0-1 seg). I could see that the process that wait for the response take a long time for locate the data in the another table. But if a simple select that I use for this, and I don't know what to do. Searching in the web I could find that there are some people with this problem, but I can't find a solution for this or a way to fix it. Somebody can help me? Orlando.
Technical Details
Message-ID:
<4162ee61$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,a61b1e0986ec1b6e,start X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Orlando Lopez" <hlopezrd@hotmail.com.do> Sender: "Orlando Lopez" <hlopezrd@hotmail.com.do> Reply-To: "Orlando Lopez" <hlopezrd@hotmail.com.do> Subject: VFP OLEDB slow Newsgroups: borland.public.cppbuilder.database.ado X-User-Info: 200.42.216.126 NNTP-Posting-Host: 207.105.83.66 Message-ID: <4162ee61$1@newsgroups.borland.com> Date: 5 Oct 2004 11:56:33 -0700 X-Trace: newsgroups.borland.com 1097002593 207.105.83.66 (5 Oct 2004 11:56:33 -0700) Lines: 20 Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail