| Author |
Message |
duck
Involved
Joined: Jul 03, 2006
Posts: 273
|
 Posted:
Wed Sep 16, 2009 9:59 am |
|
Just curious what is this tables purpose? |
| |
|
|
|
Palbin
Site Admin
Joined: Mar 30, 2006
Posts: 2583
Location: Pittsburgh, Pennsylvania
|
| Posted:
Wed Sep 16, 2009 10:19 am |
|
It is a a Memory/HEAP table that is used for the Who is Where block. |
_________________
"Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it." — Brian W. Kernighan. |
|
|
|
|
dad7732
RavenNuke(tm) Development Team
Joined: Mar 18, 2007
Posts: 1242
|
| Posted:
Mon Oct 19, 2009 11:59 am |
|
... and if you do a MySQL optimize it will show errors for those tables but not to worry, it's supposed to show errors. |
| |
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 17088
|
| Posted:
Tue Oct 20, 2009 12:33 am |
|
There is really no reason to store this data in the database and incur more MySQL overhead so I just load it into memory for super fast access  |
| |
|
|
|
|
hicuxunicorniobestbuildpc
The Mouse Is Extension Of Arm
Joined: Aug 13, 2009
Posts: 1123
|
| Posted:
Tue Oct 20, 2009 11:59 am |
|
What is the file who calls that kind of table? |
| |
|
|
|
|
Palbin
|
| Posted:
Tue Oct 20, 2009 12:17 pm |
|
Look in the block and i think there are two files within the includes folder. i can't remember the name, but they should be named as such you should recognize them. |
| |
|
|
|
|
Raven
|
| Posted:
Tue Oct 20, 2009 12:20 pm |
|
|
|
|
|
hicuxunicorniobestbuildpc
|
| Posted:
Tue Oct 20, 2009 12:39 pm |
|
Wow! This is really interesting. I found the files. Now I understand what is the meaning.  How clever you are. lol |
Last edited by hicuxunicorniobestbuildpc on Tue Oct 20, 2009 12:44 pm; edited 1 time in total |
|
|
|
|
Raven
|
| Posted:
Tue Oct 20, 2009 12:44 pm |
|
It will speed up nuke to the extent that the MySQL table I/O is sped up. Memory tables do not incur anywhere near the overhead for ISAM operations. But, they are not a general replacement for ISAM tables as they are limited as described in the link above. However, I use them in a couple of places and with hundreds of rows of non-indexed addressing and they are faster than ISAM table storage even w/o indexes. |
| |
|
|
|
|
hicuxunicorniobestbuildpc
|
| Posted:
Tue Oct 20, 2009 12:48 pm |
|
Raven. Can you update Cache Lite addon so we can speed up a little bit more loading blocks. Thanks in advance.
| Quote: | | It will speed up nuke to the extent that the MySQL table I/O is sped up. Memory tables do not incur anywhere near the overhead for ISAM operations. But, they are not a general replacement for ISAM tables as they are limited as described in the link above. However, I use them in a couple of places and with hundreds of rows of non-indexed addressing and they are faster than ISAM table storage even w/o indexes. |
Now I realize why RaveNuke is loading so fast. Cheers |
| |
|
|
|
|
|
|
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
