Subject Re: [firebird-support] Re: Natural plan on indexed column
Author Matthias Hanft
Ali Gökçen wrote:

> what is your record size?
> what are you saving in rows? divx film, mp3, mp4, jpg blobs?

Not at all :-)

ID Integer Primary Key
DATETIME Timestamp
IP Varchar(15)
PAR1, PAR2, PAR3, PAR4, PAR5 Varchar(80)
RESULT Integer
USERID Integer Foreign Key on Users(ID)
SOURCE Integer
SSL Integer

That's it.

> i think you have some problems with your HW or SW systems other than
> FB.
> 100 Mb means, more than 12MB second. even you have 1KB rows, you can
> send 10,000 rows per second in the lonely nights, not 100!

Hmmm... I'll try on a local machine (client+server on the same
machine). Maybe my LAN is just 1 Mbit/s instead of 100 Mbit/s :-)

Matthias