an index on any appropriate data (date, sum) should also help tremendously.
Thomas
"Danny Melton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi all,
>
> I am curious to know if the query times I'm seeing are reasonable or not.
> Here's my situation:
> I am using a database to
At 09:43 AM 12/18/2003, you wrote:
Hi all,
I am curious to know if the query times I'm seeing are reasonable or not.
Here's my situation:
I am using a database to keep up with web statistics. The table is
currently growing at about 2 million records a day. The sample table I am
working with has
Each line in MySQL is terminated with a semicolon (;). You can break your
query into as many lines as you need, and just end the last one with a
semicolon.
C:\mysql\bin>mysql --user=root -p
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
day, 8 February 2002 1:30 a.m.
> To: 'MySQL list (E-mail)'
> Subject: RE: long query on php
>
>
> Have you tried just putting the querys into a variable and pass the var
> along to mysql_query() ? Did it not work?
>
> ---
> Alain Fontaine
Yesterday, from savaidis:
> The obious question is: (before I test it)
> This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query("create bla".
"bla".
"bla
bla blabla
".
"bla"
."bla"
);
> So the limit isn't
Hi.
I prefer doing like this
$query = "CREATE TABLE query ";
$query .= "tabledef for col a,";
$query .= "tabledef for col b,";
$query .= "lots more table defs,";
$query .= "welcome to line 400";
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wro
Here is how I do it:
$query = "some query ";
$query.="some more of the same query ";
$query.="still more query ";
$query.="and so on... ";
$rst = mysql_query($query);
NOTE: you need to add a space at the end of each line (after the last word
and before the closing quotations) if you
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
>hi,
>
>i'm running a big query across a table containing more than 137 million rows
>comparing them to another one with about 4000 rows and i'm wondering how long it will
>still take...
>
>is there a way to see how many
l those lines are actually
just one line.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Brett Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: long query on php
He
It shouldn't be a problem as long as the syntax is right...
Gurhan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:14 PM
To: MySQL list (E-mail)
Subject: long query on php
How is possible to pass a long query to MySQL server with php?
Have you tried just putting the querys into a variable and pass the var
along to mysql_query() ? Did it not work?
---
Alain Fontaine
Consultant & Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTE
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:08 AM
> To: [EMAIL PROTECTED]; 'Nathan'
> Cc: 'MySQL'
> Subject: RE: long
Yesterday, from Nathan:
> Since PHP ignores whitespace, I think this is also acceptable:
PHP doesn't ignore whitespace in a quote. But your code is of course
correct.
> $query = "CREATE TABLE query
> tabledef for col a,
> tabledef for col b,
> lots more table defs,
> .
> welcome t
c has this high limit, no?
Makis
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 3:03 AM
> To: Nathan
> Cc: MySQL
> Subject: Re: long query on php
>
>
> Hi.
>
> I prefer doing like this
> $query
Makis
> -Original Message-
> From: Johnny Withers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 7:36 PM
> To: [EMAIL PROTECTED]
> Subject: RE: long query on php
>
>
>
> Or you could do it like this:
>
> $query="some query &quo
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:08 AM
> To: [EMAIL PROTECTED]; 'Nathan'
> Cc: 'MySQL'
> Subject: RE: long
c has this high limit, no?
Makis
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 3:03 AM
> To: Nathan
> Cc: MySQL
> Subject: Re: long query on php
>
>
> Hi.
>
> I prefer doing like this
> $query
Yesterday, from Nathan:
> Since PHP ignores whitespace, I think this is also acceptable:
PHP doesn't ignore whitespace in a quote. But your code is of course
correct.
> $query = "CREATE TABLE query
> tabledef for col a,
> tabledef for col b,
> lots more table defs,
> .
> welcome t
Yesterday, from savaidis:
> The obious question is: (before I test it)
> This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query("create bla".
"bla".
"bla
bla blabla
".
"bla"
."bla"
);
> So the limit isn't
Hi.
I prefer doing like this
$query = "CREATE TABLE query ";
$query .= "tabledef for col a,";
$query .= "tabledef for col b,";
$query .= "lots more table defs,";
$query .= "welcome to line 400";
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wro
Makis
> -Original Message-
> From: Johnny Withers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 7:36 PM
> To: [EMAIL PROTECTED]
> Subject: RE: long query on php
>
>
>
> Or you could do it like this:
>
> $query="some query &quo
Sent: Thursday, February 07, 2002 7:36 PM
> To: [EMAIL PROTECTED]
> Subject: RE: long query on php
>
>
>
> Or you could do it like this:
>
> $query="some query "
> ."some more of this query "
> ."still some more query "
>
M
> To: 'MySQL list (E-mail)'
> Subject: RE: long query on php
>
>
> Have you tried just putting the querys into a variable and
> pass the var
> along to mysql_query() ? Did it not work?
>
> ---
> Alain F
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
l those lines are actually
just one line.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Brett Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: long query on php
He
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
>hi,
>
>i'm running a big query across a table containing more than 137 million rows
>comparing them to another one with about 4000 rows and i'm wondering how long it will
>still take...
>
>is there a way to see how many
Here is how I do it:
$query = "some query ";
$query.="some more of the same query ";
$query.="still more query ";
$query.="and so on... ";
$rst = mysql_query($query);
NOTE: you need to add a space at the end of each line (after the last word
and before the closing quotations) if you
Have you tried just putting the querys into a variable and pass the var
along to mysql_query() ? Did it not work?
---
Alain Fontaine
Consultant & Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTE
On Fri, Jul 27, 2001 at 02:52:08AM -0500, ryc wrote:
>
> The question is, when do you know when to give up, and when to keep
> on trucking?
If it's still running now, I'd give up. :-)
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-
30 matches
Mail list logo
