Rob Adams napsal(a):
I have a query that I run using mysql that returns about 60,000 plus
rows. It's been so large that I've just been testing it with a limit
0, 1 (ten thousand) on the query. That used to take about 10
minutes to run, including processing time in PHP which spits out xml
60k records shouldn't be a problem. Show us the query you're making and
the table structure.
OKi98 wrote:
Rob Adams napsal(a):
I have a query that I run using mysql that returns about 60,000 plus
rows. It's been so large that I've just been testing it with a limit
0, 1 (ten thousand) on
Chris wrote:
Rob Adams wrote:
I have a query that I run using mysql that returns about 60,000 plus
rows. It's been so large that I've just been testing it with a limit
0, 1 (ten thousand) on the query. That used to take about 10
minutes to run, including processing time in PHP which spits
I have a 1 table query which returns less rows than when I have a 2 table
query using an implicit inner join or an explicit left join.
Select some, fields
From table1
Where part like '123%'
/* returns 2225 rows */
Select activePart, some, fields
From table1, table2
Where part like '123%'
an
From: "Instruct ICC" <[EMAIL PROTECTED]>
After a quick break in the john, I'm thinking perhaps table2 is not holding
unique "part"s as I was told it would.
Sanity restored. This is the case.
_
http://imagine-windowslive.com/hotma
I hope I am doing this write as this is the first time I've sent a message to a
mailing list!
I have a php script that uses cPanel to create a database. It requires the
cURL to be installed and my webhost has confirmed to me that it is installed.
I have not been able to get the script to work