|
-
Mar 22nd, 2006, 12:02 PM
#1
Thread Starter
Fanatic Member
Temp Tables in mySQL
Hi all.
Currently writing a purchasing website and have got a choice on the matter of how to create the shopping cart. Now normally, id use my own shopping cart, but the old dependable dog is tired, and want to update it, and I want to know the following information.....
Need to know how much memory TEMP tables take up in MySQL, a rough outlin in command son how to create them, what they can store and such forth.
Any links of quick lookups or tutorials would be good
Ta
Kai
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
 Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
-
Mar 22nd, 2006, 12:16 PM
#2
Re: Temp Tables in mySQL
I've never used MySQL but I did find this, and according to that article, there is an example in the MySQL manual's tutorial section (Chapter 3).
-
Mar 23rd, 2006, 07:00 AM
#3
Thread Starter
Fanatic Member
Re: Temp Tables in mySQL
Hi.
Cheers hack, got this and have a few more questions.
1. Do you have to lock the temporary table upon creation and have to select data from an existing table also upon creation or can you simply insert data?
2. If in the event that it is needed, can you change a temp table to a myISAM table with a new name, primary key properties, indexes, Etc..?
3. How does using temporary tables affect databse response time upon multiple transactions?
Ta
Kai
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
-
Mar 24th, 2006, 03:18 AM
#4
Thread Starter
Fanatic Member
Re: Temp Tables in mySQL
Threads that go BUMP in the forum!!!
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
