Performance Question

Posts   
 
    
Skeeterbug
User
Posts: 165
Joined: 21-May-2004
# Posted on: 27-Jul-2005 17:53:35   

Frans, I am saving a large file to the database (this is for testing, the app won't save large files). By large, I mean 127 megs (shame on me).

Anyways, saving the record took quite some time, but retrieving it went much much quicker (around 10-15 seconds). I was just wondering if there was a specific reason for this? Thanks!

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 27-Jul-2005 18:43:10   

My wild guess is that when you saved it, your database system had to increase the filesize of the database data file, which can take quite some time simple_smile

Frans Bouma | Lead developer LLBLGen Pro