Very slow database

Article View: borland.public.cppbuilder.database.multi-tier

Article #764

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#764

From: Martin Pennings
Date: Tue, 28 Nov 2000 00:00

17 lines
1188 bytes

Hello!

I've made an application that reads in a huge text file. This textfile
contains information which I put into a flat-file database.
I use the Paradox 7 driver for this.
The textfiles that have to be read are 670Kb, this converts to about 3700
records.
The first lets say 1000 records are read and converted very fast, the other
2700 records take about 30 minutes!
To speed things up, I deleted all indexes, and I putted the proces in a
thread. This had no effect.
Does anyone know how I can speed up this proces?
I think the problem is that every time a new record is inserted, the
application runs through the entire database. What can I do about this??
Thanks in advance!

Martin

Technical Details

Message-ID: <3a240af5_2@dnews>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,d6f3644109147f18,start
X-Google-Attributes: gidfcd2b,public
From: "Martin Pennings" <anolis@wish.net>
Subject: Very slow database
Date: 2000/11/28
Message-ID: <3a240af5_2@dnews>
X-Deja-AN: 698803820
X-Trace: 28 Nov 2000 11:43:49 -0800, 62.59.145.134
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: borland.public.cppbuilder.database.multi-tier
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600