On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or
Здравствуйте!
Интересует такой момент. Мой сайт хостится у местного провайдера. Они создали
базу mySQL где у меня и лежат таблицы для моего портала. Возникла необходимость
перенести модули (гостевая книга и фотогалерея) на новый хост. Файлы модулей я
скопировал, проблем с этим не возник
Hello to all!
has anybody got any ideas how i can speed up the following query?
it's so awfully slow (about 1 second).
the "test_item" table is the main problem. currently, it has
about 108.000 entries.
is it normal that it takes so long? and if it isn't, how can i
optimize the query? i've got
On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > I'm have a query like so
> >
> > select
> > A,
> > index_A
> > from
> > tableA
> > join tableB
> > on tableB.indexA = tableA.indexA
> >
> >
> > select
> > A,
> > index_A
> > from
> > table
I have a table with userid and text. Users write text. I want to find
the top 5 users who have the most rows in this table.
I can't seem to figure out the query.. is there a query possible to do this?
Thanks!
Peter
--
find videoblogs: http://mefeedia.com
my blog: http://poorbuthappy.com/ease/
m
Peter Van Dijck wrote:
I have a table with userid and text. Users write text. I want to find
the top 5 users who have the most rows in this table.
I can't seem to figure out the query.. is there a query possible to do
this?
Thanks!
Peter
SELECT Count(*) as Count, UserID
FROM table
GROUP BY
brilliant, that works! Thanks!
On 8/20/06, Chris W <[EMAIL PROTECTED]> wrote:
Peter Van Dijck wrote:
> I have a table with userid and text. Users write text. I want to find
> the top 5 users who have the most rows in this table.
>
> I can't seem to figure out the query.. is there a query poss
I am trying to get mysql 5 to run on my Fedora Core 4 linux. I
installed both server and client RPM files. The info is good and using that
I am trying to do the post-install. I ran mysql_install_db as a user and it
failed. Then I tried as root and it seemed to work. But one thing it says t
look in /var/lib/mysql for the error file. make sure /var/lib/mysql is
owned by mysql
Karl Larsen wrote:
I am trying to get mysql 5 to run on my Fedora Core 4 linux. I
installed both server and client RPM files. The info is good and using that
I am trying to do the post-install. I ran
Ow Mun Heng wrote:
On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
wh
Nicholas Wyatt wrote:
Hello to all!
has anybody got any ideas how i can speed up the following query?
it's so awfully slow (about 1 second).
the "test_item" table is the main problem. currently, it has
about 108.000 entries.
is it normal that it takes so long? and if it isn't, how can i
optimi
VenuGopal Papasani wrote:
Dear all,
I have a table with the following structure.
ield Type CollationNullKey Default
Extra Privileges Comment
--- -- -- ---
-
select userid,count(text) from blah group by userid;
--On August 20, 2006 7:22:59 PM +0100 Peter Van Dijck
<[EMAIL PROTECTED]> wrote:
I have a table with userid and text. Users write text. I want to find
the top 5 users who have the most rows in this table.
I can't seem to figure out the que
[ always cc the list so others can share the fix or make appropriate
comments ]
Nicholas Wyatt wrote:
hi chris,
thanks for answering! however, i do already have indexes on those
columns. all my tables use the myisam storage engine. what are the
differences you mentioned between these engines w
Hello,
we are working on a small project which needs to calculate the closest distances
from an address and/or zipcode entered into a search box. It will read from a
MySQL database of companies, which store their address and zipcodes.
looking for the best way to approach this. I've seen some zip
On Mon, 2006-08-21 at 07:39 +1000, Chris wrote:
> Ow Mun Heng wrote:
> > On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> >> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> >>> I'm have a query like so
> >>>
> >>> select
> >>> A,
> >>> index_A
> >>> from
> >>> tableA
> >>> join tableB
>
[snip]
we are working on a small project which needs to calculate the closest
distances from an address and/or zipcode entered into a search box. It
will read from a MySQL database of companies, which store their address
and zipcodes.
looking for the best way to approach this. I've seen some zipco
Mike Blezien wrote:
Hello,
we are working on a small project which needs to calculate the closest
distances
from an address and/or zipcode entered into a search box. It will read
from a
MySQL database of companies, which store their address and zipcodes.
looking for the best way to approach
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
Mike
- Original Message -
From: "Chris W" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MYSQL General List"
Sent: Sunday, August
Mike Blezien wrote:
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
The math in the link I gave you will still work for the distance
calculations, however if you want what that site does you will need
20 matches
Mail list logo
