|
|
Post by benjamin1 on Jun 17, 2009 18:29:10 GMT -5
Hi,
When designing an RB program, how much faster could a program be if it was not using any database commands. Instead of storing user information in a database it could just use text files instead. Would this make that much of a difference in speed?
|
|
|
|
Post by Carl Gundel - admin on Jun 17, 2009 21:40:05 GMT -5
SQLite is likely to be just as fast as using files, and probably faster when you have a lot of data to work through. I'd guess it depends on the kind of application you're writing.
-Carl
|
|
|
|
Post by davos1 on Jun 18, 2009 19:26:03 GMT -5
Hi, I did that tests half year ago.
RB routines that do the same that sql ran in less than 4ms via local arrays (select, insert, search,sort, create) vs 120-130 ms of a select via sql.
also, surprising, sqlite individual insert were faster that inserts command procedures.
but after a while, I decided to run using sql because it were faster to program it.
;D
|
|
|
|
Post by davos1 on Jun 18, 2009 19:27:14 GMT -5
4 ms in RB vs 120-130 ms with sqlite memory tables...
|
|
|
|
Post by Carl Gundel - admin on Jun 18, 2009 21:46:25 GMT -5
4 ms in RB vs 120-130 ms with sqlite memory tables... Yes, in-memory is always faster than disk access, but it isn't persistent. -Carl |
|
