In the original email I indicated that the 'raw' size of the records
was only 48 bytes, so these are not long records.

I have not specified the page size, but saw a note that indicated the
default page size for Firebird was 4KB; if this is not the case, how
do I set the page size when creating the database from the .Net Data
Provider using the embedded/stand-alone/single-use database?

-ken

On 20-Aug-05, at 5:00 PM, Aage Johansen wrote:

> Ken & Deb Allen wrote:
>
>> ...
>> Second, I have completed some basic tests using SQLITE comparing it
>> as much as possible with Firebird. It is not a completely fair
>> comparison because I created and populated the SQLITE database from
>> the command line tool and used a C#/.Net program for Firebird.
>> However, the same schema and data was used in both cases.
>>
>> Populating the databases with 10,000,000 records: Firebird
>> (almost 11 hours); SQLITE (about 2 hours)
>> Size of resulting database: Firebird (1.6GB); SQLITE (960MB)
>>
>
>
> Are you using very large records and a small page size? This
> (combined
> with some space reserved on each page) may result in a sparsely
> populated
> database.
> Could you try to increase page size to 4KB or 8KB?
>
>
> --
> Aage J.
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------
> ~-->
> <font face=arial size=-1><a href="http://us.ard.yahoo.com/
> SIG=12hdtig6o/M=362335.6886445.7839731.1510227/D=groups/
> S=1705115386:TM/Y=YAHOO/EXP=1124579341/A=2894361/R=0/SIG=13jmebhbo/
> *http://www.networkforgood.org/topics/education/digitaldivide/?
> source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/">In low income
> neighborhoods, 84% do not own computers. At Network for Good, help
> bridge the Digital Divide!</a>.</font>
> --------------------------------------------------------------------
> ~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>