ArcEmu: Database Growth - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Database Growth items table incomplete

#1 User is offline   shadedmagus 

  • Member
  • Pip
  • Group: Members
  • Posts: 20
  • Joined: 30-December 10
  • Gender:Male

Posted 11 January 2011 - 11:28 PM

I was looking for an item in the `items` table in the world database, and I noticed that the table is only listing about 2200 entries. This is my test server and I don't have any patches installed, but I'm curious if this is normal behavior for a new server, that the table grows as more items are loaded from the client. If needed, here's what I'm running:

ArcEmu r4012
WhyDB r151 c102
0

#2 User is offline   iEzri 

  • < Ace of spades >
  • Group: Contributor
  • Posts: 1,692
  • Joined: 22-December 08
  • Gender:Female
  • Interests:I'm likely to cause mischief
  • Server OS:Linux

Posted 12 January 2011 - 06:28 AM

View Postshadedmagus, on 11 January 2011 - 11:28 PM, said:

I was looking for an item in the `items` table in the world database, and I noticed that the table is only listing about 2200 entries. This is my test server and I don't have any patches installed, but I'm curious if this is normal behavior for a new server, that the table grows as more items are loaded from the client. If needed, here's what I'm running:

ArcEmu r4012
WhyDB r151 c102


hm, just this start page alone returns about 200 items (http://www.wowhead.com/items). Take that for every Quality and your like at 1200 items, and this is only because wowhead limits to 200 results each search.

I am not very convinced you have all items (needless to say probably no db has).
Posted Image I do not join. I lead.
0

#3 User is offline   Sadikum 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 367
  • Joined: 16-June 08
  • Gender:Male

Posted 12 January 2011 - 06:46 AM

WhyDB r151 has 37293 items. (SELECT COUNT(*) FROM `items`:(. If you've only about 2200 try to reimport a fresh items table from the SVN.
Sorry for my english, I'm french.
0

#4 User is offline   shadedmagus 

  • Member
  • Pip
  • Group: Members
  • Posts: 20
  • Joined: 30-December 10
  • Gender:Male

Posted 12 January 2011 - 10:38 AM

View PostSadikum, on 12 January 2011 - 06:46 AM, said:

WhyDB r151 has 37293 items. (SELECT COUNT(*) FROM `items`;). If you've only about 2200 try to reimport a fresh items table from the SVN.


OK...When I ran that query, it came back with 37293, but the entries start at 25 and end at 2399, with around a hundred numbers missing from within that range. I'm using Navicat to view the table; is there some filter set in place that I don't know about?

Never mind, I didn't think there would be pages in a table. :(

We now return you to your normal, common-sense programming.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users