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
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 keep up
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\binmysql --user=root -p
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
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 plan on
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 wrote:
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 also set to
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
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
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 query on php
Just a comment:
Doing so
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
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?
.
-
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
Here is how I do it:
$query = some query ;
$query
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
.some more of this query
.still some more query
There is no limit on the size of strings in PHP. Follow this link for more
info:
http://www.php.net/manual/en/language.types.string.php
Brett
Original Message Follows
From: savaidis [EMAIL PROTECTED]
To: 'Johnny Withers' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: long query
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 = CREATE TABLE query ;
$query .= tabledef for col
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 to line
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 = CREATE TABLE query ;
$query .= tabledef for col
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 query on php
Just a comment:
Doing so
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
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 plan on
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
: 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
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From
, 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
.and so on and so forth...;
;
The tabs are no needed, I just put them there to make
There is no limit on the size of strings in PHP. Follow this link for more
info:
http://www.php.net/manual/en/language.types.string.php
Brett
Original Message Follows
From: savaidis [EMAIL PROTECTED]
To: 'Johnny Withers' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: long query
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 wrote:
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 also set to
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 to line
27 matches
Mail list logo