Howdy Folks,
I have a quick question about the speed differences in creating records in temp tables and in the DB itself.
I have got a CSV file that I need a suite of progress apps to have access to. The first idea I had was to create a temp table and share it which works fine but once my application has closed I can't review the info that was loaded.
I then thought of creating a table in the DB with the exact same structure as my temp table. I pull in the data the same and I create the records the same. Using the DB allows me to review the data that was loaded and I don't need to keep loading everytime I have to restart my apps.
The big difference between these two methods that I have noticed is that it takes approx 40 secs to load into the temp table but it takes nearly twenty minutes to load into the DB!
Is there something that I am missing? There are three fields in the table and one index. The first field is an incremental record ID number that I do myself (no sequences or anything) and the other two fields are chars that are about 8 and 74 characters in length respectively. The index is primary/unique on the ID field. The database is a small one that I have created for this testing and it is local to my machine (PIII running W95 and Progress 8.3b). Oh yes, I almost forgot, there are 180,000 lines that need to be loaded.
Can someone please enlighten me on whether there are any steps that I can take to speed this process up. I know that there is going to be a lot of disk activity when writting to a DB (I have seen the lights flashing!) but is there any way of enhancing the performance?
Thanks In Advance,
James.
I have a quick question about the speed differences in creating records in temp tables and in the DB itself.
I have got a CSV file that I need a suite of progress apps to have access to. The first idea I had was to create a temp table and share it which works fine but once my application has closed I can't review the info that was loaded.
I then thought of creating a table in the DB with the exact same structure as my temp table. I pull in the data the same and I create the records the same. Using the DB allows me to review the data that was loaded and I don't need to keep loading everytime I have to restart my apps.
The big difference between these two methods that I have noticed is that it takes approx 40 secs to load into the temp table but it takes nearly twenty minutes to load into the DB!
Is there something that I am missing? There are three fields in the table and one index. The first field is an incremental record ID number that I do myself (no sequences or anything) and the other two fields are chars that are about 8 and 74 characters in length respectively. The index is primary/unique on the ID field. The database is a small one that I have created for this testing and it is local to my machine (PIII running W95 and Progress 8.3b). Oh yes, I almost forgot, there are 180,000 lines that need to be loaded.
Can someone please enlighten me on whether there are any steps that I can take to speed this process up. I know that there is going to be a lot of disk activity when writting to a DB (I have seen the lights flashing!) but is there any way of enhancing the performance?
Thanks In Advance,
James.