I grant you that, however my point was about the total count of the indexed
word's appearance, which would still stay the same, regardless of the
encoding of the position information.
Peter
<^_^>
-----
Peter Grigor
Hoobly Free Class
Peter
<^_^>
-----
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Renars Jeromans" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 18, 2003 10
Well, MySql stores all its index information in one index file, so when you
add another index it has to rebuild the WHOLE file. :)
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From:
Yes, and better go to the one across town to get it :)
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Su
That body column wouldn't happen to be a fulltext index, would it? :)
If so, 'ave another coffee.
Peter
<^_^>
---------
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "david" <[
I'm hoping that it's a MyIsam table.
Peter
<^_^>
---------
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday,
What type of platform/file system are you using?
Very large files on filesystems can suffer from inode indirection
problems...but I wouldn't think they'd be too noticeable.
Peter
<^_^>
---------
Peter Grigor
Hoobly Free Classifieds
http:
Make a temporary table, SELECT DISTINCT the rows from the old table to the
new table, rename the old table TABLE_OLD, rename the temporary table to the
original table name.
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoob
You probably have a permissions issue in your data or temp directory...Mysql
is not able to create a temporary table when making the table alteration.
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original M
I'm with you for sure...client processing is the way to go...fat servers
suck.
Peter
<^_^>
-----
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
Yep, you're right. Never noticed that before :)
I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.
Peter
<^_^>
---------
Peter Grigor
Hoobly Free Classifieds
http:
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "RBE" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 1:09 PM
Subject: Re: New Database,
> -BEGIN PGP SIGNED MESSAGE---
You need the zlib library...that's where compress is defined.
It can be found at http://www.gzip.org
Peter
<^_^>
-----
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "Ron Sorber" &
This probably isn't best handled by mysql...use associative arrays to store
members of members in the hierarchy, then print out the associative array's
contents in order.
Peter
<^_^>
---------
Peter Grigor
Hoobly Classified Ads
http:
BTW, exactly how did you acquire, install and execute mysql without visiting
mysql.com?
:)
Peter
<^_^>
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]
o build my first database,
>
> is there a comprehensive user manual on how to,
> say in .pdf format out there ?
>
> if not, a on-line link maybe ?
>
See http://www.mysql.com/documentation/index.html
Peter
<^_^>
-
Peter Grigor
Hoobly Class
re about space, a tinyint of how many bits are in the mask.
Dood, he's not gonna be very happy storing an IP as 16 bits :)
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
-
- Original Message -
From: "J. A. Tovey" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:52 AM
Subject: Re: socket error
>
> yes, i ran everything again
>
Well, the hos
- Original Message -
From: "J. A. Tovey" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:33 AM
Subject: Re: socket error
> ok :)
>
> all killed now,
>
> (not quite
> i'm sorry - could you explain that for a
> simpleton :-)
> i have no idea what you mean :-/
>
> --- Peter Grigor <[EMAIL PROTECTED]> wrote:
> > - Original Message -
> > From: "J. A. Tovey" <[EMAIL PROTECTED]>
> > To: "Pe
he database.
> I have double checked my code and it runs perfectly runs on any other
> database.
>
> Please let me know is it a bug in Mysql or the driver i am using. ???
>
> Thanx and Regards,
> RK
>
We really can't help you much unless you post your query.
Peter
<
- Original Message -
From: "J. A. Tovey" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:34 AM
Subject: Re: socket error
> ah ok, yes,
>
> the error log says
> "
>
>
> and it had returned:
>
> [1] 3698
> [root@jt mysql]# Starting mysqld daemon with
> databases from /usr/local/mysql/data
> 030211 12:32:05 mysqld ended
>From this last line you can tell that the mysqld has not started properly
('mysql ended'). That's
m A' at line 3
>
> Try to select the student who are atleast doing one computer sciencs
> subject (433123, 433252...)
You'll have to rewrite your query using an inner join...not hard.
Peter
<^_^>
-
Peter Grigor
Hoobly Classified
24 matches
Mail list logo
