> 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
