sqlite - Sqlite Versus Firebird

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 107,112 ****
  
                               File Size     Query time
  SQLite (3.2.7)            :  201,008 KB    11 s
! Firebird (1.5 Superserver):  165,268 KB     5 s
  
  For the Firebird schema, the IB DataPump reads the SQLite schema creates a Firebird schema with the text fields as memo(), which (my guess) would use more memory than varchar(n) so I redid the schema by hand using varchar(n) with appropriate values of n (since I was lazy, I set n=10 or n= 70 depending on whether the field was large or small).
--- 107,112 ----
  
                                      File Size     Query time
  SQLite (3.2.7)                   :  201,008 KB    11 s
! Firebird (1.5.2.4731 Superserver):  165,268 KB     5 s
  
  For the Firebird schema, the IB DataPump reads the SQLite schema creates a Firebird schema with the text fields as memo(), which (my guess) would use more memory than varchar(n) so I redid the schema by hand using varchar(n) with appropriate values of n (since I was lazy, I set n=10 or n= 70 depending on whether the field was large or small).