← Back to team overview

maria-discuss team mailing list archive

Re: EXPLAIN and CONNECT

 

Hi, Federico!

On May 12, Federico Razzoli wrote:
> Hi Sergej,
> 
> Thank you for this update. I'm still curious: does CONNECT read the
> rows several times? If so, is there a way to avoid this until the bug
> is solved?

I suppose you've seen the answer in the bug report. But just for the
sake of completeness I repeat it here.

CONNECT does not read rows several times. But in the CSV file format,
rows can have different lengths and CONNECT cannot directly know how
many rows your table has. So, it *estimates* the number of rows by
dividing the file length by the minimal row length (which it can
calculate from the table definition).

Regards,
Sergei


Follow ups

References