Subject | Re: [firebird-support] Re: Natural plan on indexed column |
---|---|
Author | Matthias Hanft |
Post date | 2006-03-28T16:42:32Z |
Ali Gökçen wrote:
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.
machine). Maybe my LAN is just 1 Mbit/s instead of 100 Mbit/s :-)
Matthias
> what is your record size?Not at all :-)
> what are you saving in rows? divx film, mp3, mp4, jpg blobs?
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 thanHmmm... I'll try on a local machine (client+server on the same
> 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!
machine). Maybe my LAN is just 1 Mbit/s instead of 100 Mbit/s :-)
Matthias