open All Channels
seplocked EVE Technology Lab
blankseplocked Wallet journal errors
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

CCP Elerhino


Minmatar
C C P
C C P Alliance
Posted - 2011.08.10 14:04:00 - [1]
 

FYI - we've been seeing wallet journal errors in our logs which we traced to a defect in the API which has now been fixed but won't be deployed until the end of the month. You're likely to see the error if you use a high rowcount in your requests, the workaround being to lower it to e.g. a few hundred. Wink

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.08.10 14:31:00 - [2]
 

Edited by: Hel O''Ween on 10/08/2011 14:36:38
\o/ Very Happy

Quote:

You're likely to see the error if you use a high rowcount in your requests ...



I thought I help you guys out by using the highest possible row count as it was my impression that a few "big" (rowCount=2560) queries produce less stress on the servers as a lot "little" (say rowCount=256) ones. It seems I was wrong.

[Added]
Question: From the perspective "(API) server load", what do you guys prefer us 3rd party devs to do in general? Few big queries or a lot small queries (where applicable)?

CCP Elerhino


Minmatar
C C P
C C P Alliance
Posted - 2011.08.10 15:25:00 - [3]
 

Originally by: Hel O'Ween

Question: From the perspective "(API) server load", what do you guys prefer us 3rd party devs to do in general? Few big queries or a lot small queries (where applicable)?


It depends on what data you're requesting and also what you're expecting to get - don't ask the API for data if it's likely that it hasn't changed from the last time you asked for it. E.g. in this case, if you're only expecting to see max 100 new entries in your wallet journal then only ask for 100 and in the rare cases that you get more then you can get the next page of items. Getting 2000% more data than you usually need is excessive. Very Happy

In general you need to calibrate the frequency and amount to what you need. We keep a maximum on both with restrictions and cache timers, but those maximums might very well be much more than you need. In most cases it's probably less though. Cool

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.08.11 08:35:00 - [4]
 

Thanks for the explanation.

Originally by: CCP Elerhino

E.g. in this case, if you're only expecting to see max 100 new entries in your wallet journal then only ask for 100 and in the rare cases that you get more then you can get the next page of items.Very Happy



This is not easy to guesstimate for the type of API data (all the "financials") and users ("Heavy JITA station trader running multiple accounts" down to "Mission runner looking once in a month for his bounty sum") I'm dealing with.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2011.08.14 07:18:00 - [5]
 

Could try slow start like system where you get say the average number of rows your users have and say double it each time up to max if you get full count on last query. IE get 10 first time if you got 10 use 20 on the next query when walking back then 40 etc or how ever you think they should scale. I was trying something like that in Yapeal but I think it broke for awhile with changes that CCP made that seem to have totally screwed up walking backwards. I'm not sure if it's still broken I haven't had a chance to test lately.

Klazeme
Posted - 2011.08.21 01:05:00 - [6]
 

Edited by: Klazeme on 21/08/2011 01:05:50
How about if you gave us an option to ask for all new entries since a specified date/time/transactionID/something then we wouldn't need to guess a number.

Captain Xero
Gallente
3 Star Industries
Posted - 2011.08.31 21:48:00 - [7]
 

Originally by: Klazeme
Edited by: Klazeme on 21/08/2011 01:05:50
How about if you gave us an option to ask for all new entries since a specified date/time/transactionID/something then we wouldn't need to guess a number.


+1


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only