* Maxim Veksler [EMAIL PROTECTED] [070320 19:14]:
On 3/20/07, Baruch Even [EMAIL PROTECTED] wrote:
* Maxim Veksler [EMAIL PROTECTED] [070320 15:57]:
btw, too bad http://syscalltrack.sourceforge.net/ ain't good(?) for 2.6.
You can get a similar effect by using systemtap on a kprobes enabled
I need a MySQL consultant for a small consultation (20 min.) to help
me designing a DB for ~30mil rows, whose size is about 10Gb. The
consultant must have proven experience with building using and
optimizing DBs of this scale. I only need to consult him by phone for
10-20 minutes, consultation by
Hi,
I asked this before and never really got an answer I could understand. :-(
Is there a Fedora Core 6 RPM repository mirror in Israel?
I ask as I am sitting here watching updates come down at a few K bytes
per second, while I donwload the original CD's from the local mirror
in about 1/2 hour
I have sticking problems with jpost again. I would like to confirm this
with others. Here are details:
URL:
http://www.jpost.com/servlet/Satellite?apage=2cid=1173879134668pagename=JPost%2FJPArticle%2FShowFull
Symptoms: Page loads and displays but it never finishes loading. Opening
any
Geoffrey S. Mendelson wrote:
Hi,
I asked this before and never really got an answer I could understand. :-(
Is there a Fedora Core 6 RPM repository mirror in Israel?
I ask as I am sitting here watching updates come down at a few K bytes
per second, while I donwload the original CD's
It seems that my question boils down to this:
I'm having a 3Gb table with three TEXT columns and an ID.
Counting it takes between 1 to 2 minutes, is it normal for such a size
of a table?
On 3/21/07, Elazar Leibovich [EMAIL PROTECTED] wrote:
I need a MySQL consultant for a small consultation (20
Hi Peter,
I see the problem constantly. Using Mozilla/5.0 (X11; U; Linux i686;
he-IL; rv:1.7.5) Gecko/20041108 Firefox/1.0.
- yba
On Wed, 21 Mar 2007, Peter wrote:
Date: Wed, 21 Mar 2007 14:42:19 +0200 (IST)
From: Peter [EMAIL PROTECTED]
To: IGLU [EMAIL PROTECTED]
Subject: jpost stuck
Hi Elazar,
What is it exactly that you are counting?
- yba
On Wed, 21 Mar 2007, Elazar Leibovich wrote:
Date: Wed, 21 Mar 2007 15:42:21 +0200
From: Elazar Leibovich [EMAIL PROTECTED]
To: linux-il@linux.org.il
Subject: Re: [Job] MySQL consultation
It seems that my question boils down to
The whole table. SELECT COUNT(*) FROM tbl WHERE id1;
Thanks for the speedy reply.
On 3/21/07, Jonathan Ben Avraham [EMAIL PROTECTED] wrote:
Hi Elazar,
What is it exactly that you are counting?
- yba
On Wed, 21 Mar 2007, Elazar Leibovich wrote:
Date: Wed, 21 Mar 2007 15:42:21 +0200
From:
On Wed, 21 Mar 2007, Elazar Leibovich wrote:
Date: Wed, 21 Mar 2007 16:02:22 +0200
From: Elazar Leibovich [EMAIL PROTECTED]
To: Jonathan Ben Avraham [EMAIL PROTECTED]
Cc: linux-il@linux.org.il
Subject: Re: [Job] MySQL consultation
The whole table. SELECT COUNT(*) FROM tbl WHERE id1;
Thanks for
As a work around, try to access it via the proxy nyud.net:8090 as
follows:
http://www.jpost.com.nyud.net:8090/REST_OF_URL
(it may be SLOW).
Amir
On Mar 21, 14:42, Peter wrote:
} Subject: jpost stuck problems
I have sticking problems with jpost again. I would
This is not the problem. The problem is that running Queries like:
SELECT SQL_CALC_FOUND_ROWS c.cat_ID FROM
posts AS l,post2cat AS a2c,
categories AS c
WHERE (date2006-01-01 AND date2006-01-02) AND(c.cat_ID=a2c.category_id AND
l.article_id=a2c.post_id)
AND (c.category_name=cat1 OR
On Wed, Mar 21, 2007 at 03:42:21PM +0200, Elazar Leibovich wrote:
It seems that my question boils down to this:
I'm having a 3Gb table with three TEXT columns and an ID.
Counting it takes between 1 to 2 minutes, is it normal for such a size
of a table?
I think it's pretty obvious that you
On Wed, 21 Mar 2007, Amir Plivatsky wrote:
As a work around, try to access it via the proxy nyud.net:8090 as
follows:
http://www.jpost.com.nyud.net:8090/REST_OF_URL
(it may be SLOW).
I don't think that there is a way for it to be SLOWER than NOT WORKING.
I.e. everything is relative.
Hi Elazar,
It looks to me that to speed things up you will need to re-design your
database in order to match the expected queries. In particular, you will
need to keep the table ordered by the date field which should be a key
field. You should probably split the table into several tables by
On Wed, Mar 21, 2007 at 04:42:55PM +0200, Jonathan Ben Avraham wrote:
Hi Geoffrey,
I beg to disagree. A simple redesign should do the trick. The problem IMHO
is that the query in question has to go through the whole database each
time. Busting the table up into smaller tables ordered by date
On Wednesday 21 March 2007 16:26, Elazar Leibovich wrote:
This is not the problem. The problem is that running Queries like:
SELECT SQL_CALC_FOUND_ROWS c.cat_ID FROM
posts AS l,post2cat AS a2c,
categories AS c
WHERE (date2006-01-01 AND date2006-01-02) AND(c.cat_ID=a2c.category_id
AND
On Wed, Mar 21, 2007 at 08:44:00PM +0200, Nadav Har'El wrote:
If there were (or is) such an Israeli mirror, would yum automatically use
it for Israeli users?
Does yum try to choose the best mirror based on geography, connection
speed, or anything of this sort?
Unfortunately, last time I
On Wednesday, 21 בMarch 2007 20:44, Nadav Har'El wrote:
If there were (or is) such an Israeli mirror, would yum automatically use
it for Israeli users?
The first problem is that it's not an official fedora mirror:
http://rhold.fedoraproject.org/Download/mirrors.html
So the default
On 3/20/07, Geoffrey S. Mendelson [EMAIL PROTECTED] wrote:
On Tue, Mar 20, 2007 at 03:51:50PM +0200, Hetz Ben Hamo wrote:
* can use Sane to scan a document
* can save it to PDF
* The PDF shouldn't be a dumb TIFF/JPG file page/collection, but a
real PDF (so I can search/grep for words in the
On Wednesday 21 March 2007, Jonathan Ben Avraham wrote:
Hi Geoffrey,
I beg to disagree. A simple redesign should do the trick. The problem IMHO
is that the query in question has to go through the whole database each
time. Busting the table up into smaller tables ordered by date keys and
On Wed, Mar 21, 2007 at 11:09:21PM +0200, Shlomi Fish wrote:
However, I disagree with Geoffrey on the fact that you need Oracle or DB2 or
a
different operating system than Linux (or BSD). By all means, Linux runs very
well on this hardware, and PostgreSQL and MySQL are as fast as Oracle or
Hi Geoffrey!
On Wednesday 21 March 2007, Geoffrey S. Mendelson wrote:
On Wed, Mar 21, 2007 at 11:09:21PM +0200, Shlomi Fish wrote:
However, I disagree with Geoffrey on the fact that you need Oracle or DB2
or a different operating system than Linux (or BSD). By all means, Linux
runs very
On Wed, 21 Mar 2007, Geoffrey S. Mendelson wrote:
With 30 million records in a database, I would seriously consider
a different hardware platform. Some of the perform quite well with
Linux some do not.
30 million records is not a lot. But it is too much if one expects to
write things like
By the way, for example on how NOT to do SQL web programming see the
white pages service at fwd.pulver.net or the search in Skype. Both of
these have well under a million records usually and it takes minutes to
hours to get answers. At least Skype starts displaying as soon as there
is data.
On Thu, 2007-03-22 at 00:20 +0200, Peter wrote:
You also
probably want to read up on more advanced indexing methods (like Bloom
and Blooming filters and such) than what's available with ordinary off
the shelf databases.
I searched for information about Blooming filters.
Google gave me
26 matches
Mail list logo