Click here to Skip to main content
15,907,281 members

Comments by Aero72 (Top 16 by date)

Aero72 16-Aug-12 4:46am View    
Apologies, Espen - I didn't answer your question: What I'm presently testing requires a rate of 24k inserts/s, and I can imagine this being as high as 40k inserts/s in worst-case.

What I'm seeing at present is that I'm losing blocks of data because its not quick enough at inserting, and the gui update is significantly slowed down.

There is one table consisting of an auto-increment column plus the five items of data you can see in my code above e.g _ydata = mr.ReadSingle()


I'll have a go at patching in Raptor instead of Firebird.

Thanks and Regards,

Aero
Aero72 15-Aug-12 18:23pm View    
Thanks Espen - I'll take a look.
Aero72 15-Aug-12 11:23am View    
Thanks for trying Espen - I'm sure getting data out of the tables would be fine, but unfortunately it looks like adding records to the database in the first place kills the app, even if one transaction consists of (many) multiple inserts before committing the data.....I've also tried it using embedded firebird and the .NET provider - and its faster at writing to the db than Esent, but still not quick enough :-(

Thanks again,

Aero
Aero72 11-Aug-12 6:24am View    
That looks good.....I have some reading to do! Many Thanks Espen, I'll report back when I've tried it. My 5.
Aero72 7-Aug-12 4:22am View    
Thanks SA, As you suggest I should be able to seek somewhere near because of the chronological order of the file. I'll read a sizeable portion of the file at a time and report back - I'll take a look at BufferedFileReader