> From: Lucio Chiappetti
>
> On Tue, 7 Apr 2015, shawn l.green wrote:
>
>> The advantage to using temporary tables is that they can have indexes on
>> them. You can create the indexes when you create the table or you can ALTER
>> the table later to add them.
>
> if they are big, using proper
On Tue, 7 Apr 2015, shawn l.green wrote:
Temporary tables are going to become your very good friends.
yes I do use temporary tables a lot
The advantage to using temporary tables is that they can have indexes on
them. You can create the indexes when you create the table or you can
ALTER the
On 4/7/2015 4:12 PM, Rajeev Prasad wrote:
hello Masters,
I am a novice, and I am wanting to know how to achieve this:
1million plus row in a table.
user runs a search, gets some results. I want to store this result in memory in
a way, so that user can fire more SQL searches on this result. How
W dniu 07.04.2015 o 22:12, Rajeev Prasad pisze:
1million plus row in a table.
user runs a search, gets some results.
MySQL comes with query-cache, once you run your SELECT statement the
results are kept in memory. Try it by running big query and then rerun
it, the second time it will take m
hello Masters,
I am a novice, and I am wanting to know how to achieve this:
1million plus row in a table.
user runs a search, gets some results. I want to store this result in memory in
a way, so that user can fire more SQL searches on this result. How is this
done? I want this to go atleast upto
This worked. Thanks very much for your help!
Charles
On 12/1/06, mos <[EMAIL PROTECTED]> wrote:
At 05:37 PM 11/30/2006, Charles Danko wrote:
>Hi,
>
>I am trying to write a new table into main memory, but I am getting an
out
>of memory error.
>
>Each entry consists of 2 medium_int and 1 tiny_
At 05:37 PM 11/30/2006, Charles Danko wrote:
Hi,
I am trying to write a new table into main memory, but I am getting an out
of memory error.
Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
contains just over 100,000,000 rows. By my count, this makes just over
700MB
Hi,
Thanks for the responses!
I am creating the table from an existing (MyISAM) table using the command:
CREATE TABLE memRAW (mID SMALLINT NOT NULL, pID MEDIUMINT NOT NULL, mp
TINYINT NOT NULL) ENGINE = MEMORY SELECT * FROM RAW;
The error that I get is in the MySQL client application:
ERROR 11
Hi Charles,
Charles Danko wrote:
Each entry consists of 2 medium_int and 1 tiny_int variables, and the
table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The machine I am using has 2GB, but I am still getting an
out of memory error. What am I doing wr
Charles Danko wrote:
> Hi,
>
> I am trying to write a new table into main memory, but I am getting an out
> of memory error.
>
> Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
> contains just over 100,000,000 rows. By my count, this makes just over
> 700MB of data.
Hi,
I am trying to write a new table into main memory, but I am getting an out
of memory error.
Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The machine I am using has 2GB, but
Hi,
HEAP tables don't currently support TEXT/BLOB columns.
My answer about storing the table "in memory": don't bother.
If you have enough free RAM to use to put the table "in memory," the OS
will already do it for you after it's accessed. Thus, reading the ta
Maybe look at using a HEAP table? Load it on startup from a datasource..
On Wed, 5 Nov 2003, Arnoldus Th.J. Koeleman wrote:
>
>
> I have a large table which I like to store into memory .
>
>
>
>
>
>
>
> Table looks like
>
>
>
> Spid_1__0
>
>
>
> (recordname varchar(20) primary key,
>
>
>
> dat
I have a large table which I like to store into memory .
Table looks like
Spid_1__0
(recordname varchar(20) primary key,
data blob not null
)
what is the best way todo this in mysql
14 matches
Mail list logo
