Subject | Re: Natural plan on indexed column |
---|---|
Author | Ali Gökçen |
Post date | 2006-03-29T08:26:46Z |
Hi Matthias,
I hope your page size and disk block size match, like as at last 4KB.
Also, exclude your fdb file type from antivirus programs, system
restore services.
Problem here is Foreign Key i think.
It was a genetic promlem of FB and fixed in FB v2.
if your referance column has thousands dulicates, don't use foreign
key declaration. FB losts itself repeated index nodes with DISK I/O.
Try to create your custom based integrity control system.
or your physical layer has some problems. :)
Regards.
Ali
> > what is your record size?4+8+17+5*82+4+4+4+4 = 455 bytes, not so big.(confession: calc used)
> > 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 hope your page size and disk block size match, like as at last 4KB.
Also, exclude your fdb file type from antivirus programs, system
restore services.
Problem here is Foreign Key i think.
It was a genetic promlem of FB and fixed in FB v2.
if your referance column has thousands dulicates, don't use foreign
key declaration. FB losts itself repeated index nodes with DISK I/O.
Try to create your custom based integrity control system.
>than
> > i think you have some problems with your HW or SW systems other
> > FB.can
> > 100 Mb means, more than 12MB second. even you have 1KB rows, you
> > send 10,000 rows per second in the lonely nights, not 100!May be, if you have Wi-fi components in your LAN,
>
> 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
>
or your physical layer has some problems. :)
Regards.
Ali