Template too slow after 100 record.

[exproof]

Hi,
Thanks for your product.
I have problem with template clonerow.
I have approx 150 record and template create document approx 500 second. is it normal?

Hi, @exproof. Could you please give me the code you benchmark with?

[exproof]

if you need full code and template.docx i can send via e-mail.

$Document->cloneRow('A01Sira', mysql_num_rows($Sorgu));
while ($Satir<mysql_num_rows($Sorgu))
{
//Sabit Alanlar Gidiyor
$Document->setValue('A01Sira#'.($Satir+1), ($Satir+1));
$Document->setValue('A01Urun#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"UrunAdi")));
$Document->setValue('A01Ilce#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"IlceAdi")));
$Document->setValue('A01Koy#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"KoyAdi")));
$Document->setValue('A01Mevki#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"BeldeAdi")));
$Document->setValue('A01Ada#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"Ada")));
$Document->setValue('A01Parsel#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"Parsel")));

$MusteriAdi=TemizGoster(mysql_result($Sorgu,$Satir,"MusteriAdi"));

switch ($Secenek)
{
    case 1:
        $Document->setValue('A01Uretici#'.($Satir+1), $MusteriAdi);
        if (strlen(trim(mysql_result($Sorgu,$Satir,"VergiNo")))>0)
        {
            $Document->setValue('A01Tc#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"VergiNo")));   
        }
        else
        {
            $Document->setValue('A01Tc#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"TcKimlikNo")));
        }
        $Document->setValue('A01Adres#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"MusteriAdresi")));
        $Document->setValue('A01Telefon#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"MusteriTelefon")));
    break;

    case 2:
        $Document->setValue('MusteriAdi',$MusteriAdi);
        $Document->setValue('MusteriAdresi',TemizGoster(mysql_result($Sorgu,$Satir,"MusteriAdresi")));
        $Document->setValue('MusteriVergiNo',TemizGoster(mysql_result($Sorgu,$Satir,"MusteriVergiNo")));
        $Document->setValue('A01Uretici#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"UreticiAdi")));
        $Document->setValue('A01Tc#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"VergiNo")));
        $Document->setValue('A01Adres#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"UreticiAdresi")));
        $Document->setValue('A01Telefon#'.($Satir+1), TemizGoster(mysql_result($Sorgu,$Satir,"UreticiTelefon")));
    break;  
}

$Satir++;

}

I see that TemplateProcessor::cloneRow is called on the first line only. What is execution time of this statement?

[exproof]

Approx 10 minute ;) This query result 175 record. What is your suggestion. Must i use every line not only first line?

Wow. That's terrible. Please, give me your template file. Share it with any file sharing service like Dropbox, Google Drive, etc. and post link here.

[exproof]

Code, Template and Result files

2015-03-30 7:23 GMT+03:00 Roman Syroeshko notifications@github.com:

Wow. That's terrible. Please, give me your template file. Share it with
any file sharing service like Dropbox, Google Drive, etc. and post link
here.

—
Reply to this email directly or view it on GitHub
#513 (comment).

[exproof]

i am newbie in github i reply your last post with attach files vie gmail. I hope you can take attach files. Thank for your support.

Nope. No luck. Share it using your Google Drive.

[exproof]

https://drive.google.com/folderview?id=0B8M9akXaBDfNfkRWVUVoSGZtRUU1eFBJTC03VGJOYmN5U1l4WEpqckp5bG5FRGNOMnVhekU&usp=sharing

[exproof]

3 files in drive. Code, Template and Query Result