DVL Software Limited
[ About | Services | Products | Search | Feedback | Support ]

PowerBuilder Tips

Importing large amounts of data

Back to the Tips


We've been importing large amounts of data which must be manipulated before it is stored in the database.

One import consists of 365 days of 1/2 hours readings, or about 17,000 rows of data.   To just store 17,000 rows of data takes a long time.  To speed that up, we denormalised the data and stored 365 rows of 48 columns per row.  But the processing to convert from 17,000 rows to 365 rows took too long.  So we wrote a DLL using Delphi.  The DLL routine takes hardly any time to convert the file from 17,000 to 365 rows.  Then the RowsImport() gets it's data in the correct format and all we do is an Update().  Very simple.  Very fassssssssssssssssst!

So if you need massive amounts of data manipulated and it's taking too long, I suggest you think about third party products, such as Delphi, to fill the gap.  Not everything in your application must be PowerBuilder.


Back to the Tips

[ About | Services | Products | Search | Feedback | Support ]

This page last updated: Wednesday, 23 February 2000
Copyright 1997, 1998, 1999, 2000 DVL Software Limited.  All rights reserved.