MAX LIMIT of registers

[juque]

Hi all.

I have the next code (from php.net)

$row = 1;
$fp = fopen ("test.csv","r");
while ($data = fgetcsv ($fp, 1000, ",")) {
    $num = count ($data);
    print "<p> $num fields in line $row: <br>";
    $row++;
    for ($c=0; $c<$num; $c++) {
        print $data[$c] . "<br>";
    }
}
fclose ($fp); 

What is the MAX LIMIT of registers that I can read from my cvs file?
20,000 50,000 100,000... ?

thanks.

[Technosailor]

Um, not sure, but if you are seriously playing with numbers even half that big, why don't you use a real RDBMS - or at least MySQL? Your text file is going to bark at you real quick...

[juque]

that's the idea; really i want to insert all this register into SQL Server Database. The example is just for to show the fgetcsv function.

OK, the real problem is : i want to read registers from CSV file... but I want to filter register to register if is in the table or if isn't.

while ($data = fgetcsv ($fp, 1000, ",")) 
    {
    //pseudocode

     if the register IS in my table 
           to DO a UPDATE
     if the register is NEW 
            to DO a INSERT 
    }
}