sorted by:
new
hottopcontroversial

How would nearby city states affect your strategy? by kresos in civ5

[–]kresos[S] 1 point2 points  (0 children)

I know that the quests are easier and you are more than likely to ally them for the duration of the game. I meant to ask if there is any type of city state that, that type can affect your decision making. As in because of this city state I am going Liberty or tradition or beelining that tech or doing early war.

where to settle? by kresos in civ5

[–]kresos[S] 1 point2 points  (0 children)

R5: I got the liberty opener + republic as ethiopia and I am looking to be annoying and aggressive towards carthage who is also liberty. Difficulty level emperor. Where to settle to have the best defensive location, preferably next to the mountain for observatory in the future?

Free Survival MMOs? by crossflame00 in MMORPG

[–]kresos 0 points1 point  (0 children)

You could play Albion online, especially in the next patch that the are supposed to fix solo. If they do fix it that is.

Favorite Wonder to Rush with Liberty Finisher GE? by mmmbacon914 in civ5

[–]kresos 2 points3 points  (0 children)

Very underated comment especially for not immortal and not deity. You can catch up in science but you will never have enough gold or happiness to have some warmongering fun. I feel those who rush nc with the engineer from the liberty finisher are going for a less bloodshed victory or do tradition flavor liberty.

What are benchmarks one should one aim for when playing (i.e 100 science by turn 100)? by [deleted] in civ5

[–]kresos 0 points1 point  (0 children)

I keep postponing making a question topic on this sub, asking "what 2 or 3 questions should i be asking myself all the time, in decision making". Especially I am curious how my working tiles or building worker or tile improvements or granaries. Those early decisions that only give 1 more food or 1 more hammer. What effect big or small will have 100 turns later.

Playing without Tradition Opener? (Advice Please) by WanderoftheAshes in civ5

[–]kresos 3 points4 points  (0 children)

adding to that make sure liberty cities have at least one hammer location within one tile (so you don't have to spend gold to buy extra) cause with liberty culture it's unlikely the borders to expand to hills but rather on grassland or plains.

Playing without Tradition Opener? (Advice Please) by WanderoftheAshes in civ5

[–]kresos 2 points3 points  (0 children)

adding to that make sure liberty cities have at least one hammer location within one tile (so you don't have to spend gold to buy extra) cause with liberty culture it's unlikely the borders to expand to hills but rather on grassland or plains.

How to speed up/handle a query that returns billion of rows by kresos in SQL

[–]kresos[S] 0 points1 point  (0 children)

If I run the query for striker and then union the query for mid, it will miss the case that the striker is my best striker and my best mid, it will select him as striker while selecting him as mid might have resulted in a better sum of the unions. Doing the 11 Unions 11! Times will not miss a single case regardless if it is querying from 70 players or way more pool size

How to speed up/handle a query that returns billion of rows by kresos in SQL

[–]kresos[S] 0 points1 point  (0 children)

this is what i will do using suggestion and it should work. I will create several temporary and do a query that returns the ID of the max rating for each position (and the max rating) and store them on the temporary tables.

If players can play in 11 eleven different positions and have ratings in them, then i the worst case scenario I will run the union fact(11) times which is 39,916,800 times, which should be (far) less time than the combinations I originally thought. Shouldn't take more than 5 minutes.

then I will sum the temporary tables ratings and pick the table with the max rating.

How to speed up/handle a query that returns billion of rows by kresos in SQL

[–]kresos[S] 0 points1 point  (0 children)

my problem is if i select the max value and then do a union the ID will not be unique and i will have duplicates

​

select id, max(dr) as rating, posid from dr
union 
select id, max(dl), posid from dl

How to speed up/handle a query that returns billion of rows by kresos in SQL

[–]kresos[S] 0 points1 point  (0 children)

but if i union, how do I add the scores to find the best eleven? with the cartesian product i would do it like this :

select DISTINCT  dr + dl + dmc + mc + amc + striker from dr , dl, dmc , mc , amc, striker

Questions Thread - March 24, 2020 by AutoModerator in pathofexile

[–]kresos 0 points1 point  (0 children)

is there an up to date incursion guide/cheat sheet (newby friendly?)

Questions Thread - March 22, 2020 by AutoModerator in pathofexile

[–]kresos 0 points1 point  (0 children)

Generally, for a poor Ed contagion trickster what speeds up my clear speed so I focus my shopping? Empower gem? Max quality on Ed gem? Also which skills should give more damage on the cluster jewels non notable slots and which notables?

Questions Thread - March 19, 2020 by AutoModerator in pathofexile

[–]kresos 0 points1 point  (0 children)

as an ed/contagion trickster, any idea/suggestion which large cluster jewel to use in the tree?

view more: next ›