Ja se izvinjavam, bio sam malo pijan kad sam pisao prosli odgovor, nije to ono sto mi treba...
Ja imam ovakav kod, i on radi, ali(uvek ima ali):
[note]
tabela1 = 30000 podataka
tabela2 = 20000 -||-
tabela3 = 15000 -||-
PHP kôd:
$query = pg_query(SELECT number FROM tabela1);
while($row = pg_fetch_array($query)) {
$number = $row['number'];
$num1 = substr($number,0,3);
$num2 = substr($number,3,2);
$num3 = substr($number,5,1);
$query2 = pg_query("SELECT field1 FROM tabela2 WHERE field2='$num1' AND field3='$num2' AND field4='$num3'");
while($row2 = pg_fetch_array($query2)) {
$field1 = $row2['field1'];
$query3 = pg_query("SELECT field2 FROM tabela3 WHERE field1='$field1'");
while($row3 = pg_fetch_array($query3)) {
$field2 = $row3['field2'];
$query4 = pg_query("INSERT INTO tabela4 VALUES('','$number','$field1','$field2')");
}
}
}
eh, sada mene interesuje da li ovaj kod moze da se optimizuje malo?