AH Query Results

[Bleckpan]

I am trying to create an add-on that will grab all the glyph prices off of the AH. However, when I call

QueryAuctionItems("Glyph", nil, nil, nil, 5, nil, nil, false, nil, true)

and put that data into tables with

numBatchAuctions, totalAuctions = GetNumAuctionItems("list")
Glyph_Count = totalAuctions
for Glyph_Number = 1, Glyph_Count do
local name, _, count, _, _, _, minBid, _, buyoutPrice, _, _, _, _ = GetAuctionItemInfo("list", Glyph_Number) 
-- if string.find (name, "Glyph") == nil then return end
Glyph_List_Names [Glyph_Number] = name
Glyph_List_Count [Glyph_Number] = count
Glyph_List_MinBid [Glyph_Number] = minBid
Glyph_List_MinBO [Glyph_Number] = buyoutPrice

I end up with tables of all 18 thousand auctions on the auction house. Using string.find as a workaround will result in having four empty tables. Does the fault lie in querying or saving?
Here is my full code:http://pastebin.com/qB6vydkV.
Thanks in advance!

[lilsparky]

that last "true" in your query is the "getall" flag. if you set that to true, it gets every item at the auction house.

[SDPhantom]

if string.find (name, "Glyph") == nil then return end

This kill kick out of the function if the first auction item isn't a glyph and ignore everything else.

[Bleckpan]

After messing around with going through each page, I decided using http://pastebin.com/nBXFi5av may be easier/quicker. But of course not!

After querying the auction house, my client decides to "freeze" up. My cursor still responds when when I move my mouse, but the UI does not respond to anything. After about 15 min, I get the "disconnected from server" popup.

Is this a result of using too much memory? It hits about 78 MB before it freezes up. Is there a more efficient way of putting data into tables than this?

for Item_Number = 1, wholeCount do
 name, _, _, _, _, _, _, _, buyoutPrice, _, _, _, _ = GetAuctionItemInfo("list", Item_Number) 
  if string.find(name, "Glyph") == 1 then
  Glyph_List[Glyph_Count] = {name, buyoutPrice}
  Glyph_Count = Glyph_Count + 1
  end
 end

[SDPhantom]

What's happening is your code is going in its loop through 18k entries. This doesn't happen instantly, it takes a lot of processing. While the loop is running, Wow can't do anything, even communicate with the server. What many scanners do is hook their processing code with the OnUpdate handler of a frame and scan through a limited number of entries per frame, then let WoW do what it needs to do before continuing.