🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1149

VFP OLEDB slow

#1149
From: Orlando Lopez
Date: Tue, 05 Oct 2004 18:56
19 lines
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-mail

Show 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