Is it possible that the tables at school are not indexed?
berber
-Original Message-
From: Paolo Bonavoglia [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 25, 2003 7:55 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] SQL very fast here & very slow there
At 16:43 24/01/2003 2
At 16:43 24/01/2003 24/01/2003, John A DAVIS wrote:
We had a very sluggish SQL Server 7.0 and we tested the RAM chips and
found one to be bad. It was throwing off a whole bank of chips (1gb).
Stuff is a lot faster now.
Also, your indexes might be different on your tables. Indexing the correct
f
I'm not sure how Paradox works, but it may be locking problems you are
running into. I know Paradox used to have issues with data changing
while a query was executing. On your home machine you are the only one
accessing the DB, so there wouldn't be any contention. Your home DB
probably hits the
I have realized a php web page with this "heavy" SQL query, necessary to
show a list of students:
$sqlcom = "SELECT Alunni.Cod_Alunno, Nome, Cognome, Scritto, Orale, Assenze
FROM Alunni, Scrutini, Iscritti
WHERE Alunni.Cod_Alunno = Scrutini.Alunno AND Scrutini.Alunno =
Iscritti.Cod_Alunno
AND
