← Back to team overview

maria-discuss team mailing list archive

Re: EXPLAIN and CONNECT

 

maybe include at extra "estimative rows count"
just to understand what happened


2014-05-26 17:07 GMT-03:00 Sergei Golubchik <serg@xxxxxxxxxxx>:

> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

Follow ups

References