BorlandTalk.com

Swaminathan B · Guest

hi i have a table from where the data are stored on batch number. for
every record in the batch there is a unique id assigned and the id is
assigned sequentially but will not be in batch order. since which ever
batch is processed first gets the id. i have to write few data to a
file sorted on this id. so i'm using a tadodataset to add these values
and then i'm sorting the records and writing to the file. the file can
be as large as 300 MB. i use block write to write exactly the 620 bytes
per line as per the file layout. for approximately 2,00,000 records the
time taken to add to the dataset is around 2 hours and then to write to
file it takes 4 hours. the problem i'm facing is after more than 80 MB
size is reached the writing to file is really slow. is there a quick
way to write to a file apart from block write. another problem is i
cannot sort the table. only i can pick up based on batch order and sort
in the memory.