*** 1,10 **** ! The Default complilation use -O6 which doen't exist with gcc (=-O0) using -O3 -Os improve the performance of sqlite. Michel Weinachter 2004-10-6 ---- ! Benchmarks already run show that SQLite has outstanding performance, even compared with MySQL, which has been the consistent speed demon of choice for web applications. However, these benchmarks have the caveat that they were run on single connections to the databases in question and no attempt was made to see how well SQLite or the other RDBMSs handled concurrent connections. This is a big deal with web apps. From experience I can testify that MySQL already performs very well with hundreds of concurrent connections. Does anyone have experience with SQLite in this regard? --Carl Youngblood ---- --- 1,16 ---- ! The Default complilation use -O6 which doen't exist with gcc (=-O0) using -O3 -Os improve the ! performance of sqlite. Michel Weinachter 2004-10-6 ---- ! Benchmarks already run show that SQLite has outstanding performance, even compared with MySQL, ! which has been the consistent speed demon of choice for web applications. However, these ! benchmarks have the caveat that they were run on single connections to the databases in question and ! no attempt was made to see how well SQLite or the other RDBMSs handled concurrent connections. ! This is a big deal with web apps. From experience I can testify that MySQL already performs very well ! with hundreds of concurrent connections. Does anyone have experience with SQLite in this regard? --Carl Youngblood ---- *************** *** 22,28 **** This will make SQLite write all the data to the disk in one go, vastly increasing performance. ! However, if you are writing to a temporary table, transactions have less effect because disk writes are not _flushed_ to the table after each write. I did a timed test with inserting 1000 records into a table in various ways to compare performance: --- 28,35 ---- This will make SQLite write all the data to the disk in one go, vastly increasing performance. ! However, if you are writing to a temporary table, transactions have less effect because disk writes are ! not _flushed_ to the table after each write. I did a timed test with inserting 1000 records into a table in various ways to compare performance: *************** *** 31,37 **** *: temporary table without transaction - 2 seconds *: temporary table with transaction - 0.1 seconds ! So, performance is still vastly quicker with a transaction when writing to a temporary, but transactions have the drawback of locking the entire database file for the duration of the transaction, even though only a temporary file is being written to, so, in multithreaded applications, it may be worth putting up with the lower performance to avoid this database locking behaviour. --Paul Smith --- 38,47 ---- *: temporary table without transaction - 2 seconds *: temporary table with transaction - 0.1 seconds ! So, performance is still vastly quicker with a transaction when writing to a temporary, but transactions ! have the drawback of locking the entire database file for the duration of the transaction, even though ! only a temporary file is being written to, so, in multithreaded applications, it may be worth putting up ! with the lower performance to avoid this database locking behaviour. --Paul Smith *************** *** 54,60 **** ---- _E. Russel Harvey on 2004-09-25:_ ! Does a transaction caused file locking prevent not only writing but also reading from other access, which may be from a thread of the same process that SQLLite is running? ---- --- 64,71 ---- ---- _E. Russel Harvey on 2004-09-25:_ ! Does a transaction caused file locking prevent not only writing but also reading from other access, ! which may be from a thread of the same process that SQLLite is running? ---- *************** *** 84,87 **** --- 95,100 ---- *: Dual Pentium 4 @ 2.6GHz *: 1GB RAM + Comment by Oliver Leu: Please post your shell scripts. Are you creating a process for every record you + insert into the db? This would slow down the process of inserting records extremly. ----
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|