• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 21:45
CEST 03:45
KST 10:45
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
Serral wins HomeStory Cup 2914Serral wins Maestros of the Game 243ByuL, and the Limitations of Standard Play3Team Liquid Map Contest #22: Results and Winners7Code S Season 2 (2026): RO4 and Finals Preview12
Community News
Weekly Cups (July 27-Aug 2): SHIN's big week0SC4ALL II: Brood War - $2500 - Dec 5-68SC4ALL II announced - $10,000 prize pool, Dec 5-64PIG STY FESTIVAL 8.0! (13 - 23 August)14Neeb returns to progaming; rejoins ONSYDE18
StarCraft 2
General
protoss aoe skill expression 5.0.16 patch for SC2 goes live (8 worker start) StarCraft 2 at SC4ALL II Invite #3/8 - Clem Balance hotfix patch 5.0.16b (July 16) Clem: "I don't have that much hope in Blizzard"
Tourneys
PIG STY FESTIVAL 8.0! (13 - 23 August) Tasteless Time Warp: SC Evo Showmatch (May 25) SC4ALL II announced - $10,000 prize pool, Dec 5-6 Sparkling Tuna Cup - Weekly Open Tournament RSL Revival: Season 6 - Qualifiers and Main Event
Strategy
[G] Having the right mentality to improve
Custom Maps
Nexus Wars 2021 GUIDE [M] (2) Industrial Park
External Content
The PondCast: SC2 News & Results Mutation # 537 Hostile Territory Mutation # 536 Railroad Switch Mutation # 535 Assembly of Vengeance
Brood War
General
ASL 22 Proposed Map Pool Making an Online Broodwar Manager Game ASL22 General Discussion [Personal Project Share] Terran Defense v0.60 Data needed
Tourneys
KCM Race Survival 2026 Season 3 Small VOD Thread 2.0 SC4ALL II: Brood War - $2500 - Dec 5-6 [Megathread] Daily Proleagues
Strategy
Any training maps people recommend? Fighting Spirit mining rates Simple Questions, Simple Answers Odyssey Mineral Stack Saturation
Other Games
General Games
General RTS Discussion Thread Stormgate/Frost Giant Megathread Nintendo Switch Thread ZeroSpace Early Access is Now Live! Beyond All Reason
Dota 2
Looking for a Dota Mentor Official 'what is Dota anymore' discussion
League of Legends
[TL LoL EUW IHs] Teemo shall perish TSM pausing esports and CLG Dead
Heroes of the Storm
Heroes of the Storm 2.0
Hearthstone
Deck construction bug
TL Mafia
TL Mafia Power Rank TL Mafia Community Thread NeO.D_StephenKing vs This Guy From 1 Million Dance
Community
General
US Politics Mega-thread European Politico-economics QA Mega-thread The Games Industry And ATVI Russo-Ukrainian War Thread Artificial Intelligence Thread
Fan Clubs
The Clem Fan Club INnoVation Fan Club The Scarlett Fan Club
Media & Entertainment
Anime Discussion Thread Movie Discussion! Series you have seen recently... [Req][Books] Good Fantasy/SciFi books
Sports
Football (Soccer) Thread TeamLiquid Health and Fitness Initiative For 2023 Formula 1 Discussion MLB/Baseball 2023 McBoner: A hockey love story
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread Simple Questions Simple Answers FPS when play League Of Legend on laptop
TL Community
The Automated Ban List Northern Ireland Global Starcraft
Blogs
Please support my new stand…
Peanutsc
What is a Gamer?
TrAiDoS
Hello guys!
LIN1s
ASL S22 English Commentary…
namkraft
Poker (part 2)
Nebuchad
Customize Sidebar...

Website Feedback

Closed Threads



Active: 4534 users

The Big Programming Thread - Page 1018

Forum Index > General Forum
Post a Reply
Prev 1 1016 1017 1018 1019 1020 1032 Next
Thread Rules
1. This is not a "do my homework for me" thread. If you have specific questions, ask, but don't post an assignment or homework problem and expect an exact solution.
2. No recruiting for your cockamamie projects (you won't replace facebook with 3 dudes you found on the internet and $20)
3. If you can't articulate why a language is bad, don't start slinging shit about it. Just remember that nothing is worse than making CSS IE6 compatible.
4. Use [code] tags to format code blocks.
zatic
Profile Blog Joined September 2007
Zurich15366 Posts
May 27 2020 14:41 GMT
#20341
On May 27 2020 10:47 travis wrote:
That's actually more complicated than I need. The game won't have any spatial aspects, so no movement. Just conversation, so just text output and maybe some input.

Python is totally fine for that then. This sounds like a really simple flask or bottle app?
ModeratorI know Teamliquid is known as a massive building
Yurie
Profile Blog Joined August 2010
12141 Posts
Last Edited: 2020-05-27 16:00:05
May 27 2020 15:59 GMT
#20342
https://www.renpy.org/ An engine made for visual novels.

And since I fully missed the web part of the requirement and don't want to look stupid. https://renpy.beuc.net/
Deleted User 3420
Profile Blog Joined May 2003
24492 Posts
May 27 2020 16:09 GMT
#20343
Yurie you are a god

thanks everyone
JimmyJRaynor
Profile Blog Joined April 2010
Canada17722 Posts
Last Edited: 2020-05-31 13:17:28
May 31 2020 12:58 GMT
#20344
On May 07 2020 19:47 Manit0u wrote:
On another note, I'll have some fun in one side project now. Will be working with C code that was last touched in 1998.

how is it going so far?

I love these types of situations in the software development industry... that is, going through ancient code.

I've been doing the hermit-coder//"Bob Fitch" thing for several weeks now. A nursing org is replacing/overhauling a Contact Tracing Application made with CA-Clipper in the 1990s. The system's last big update occurred in 2005. It had major upgrades from 1995 to 2005. There is zero documentation. The last programmer who worked on the system is in his 60s. He experienced a major health catastrophe six months ago. I get what info I can from him. He charges the nursing org $200/hour so my time with him is very limited. There is one business analyst still working at the nursing organization that used this application. She has a vague recollection of how the system worked.

My best source of info : Turn on the Tracer and step through the code one line at a time.

Hermit Coder War Stories are the best...

Bob Fitch rescued the Starcraft 1 project by locking himself in a room for several weeks/months and making the SC1 engine.

I've been doing a similar thing for the last two months. I've been tasked with jamming together a project in a very unreasonably short timeline.

I've done the hermit coder thing several times in my career. It has built me some major street cred with project managers and CIOs. Some people can't handle it for whatever reason. I'm an only child and grew up only with my mom. As a child and teenager I had the whole house to myself a lot. So doing the hermit coder thing is right in my comfort zone.

I hear people whine, bitch, moan and complain about "crunch time". Personally, I love it. I'm having a blast.

On May 07 2020 03:27 Manit0u wrote:
Unfortunately this is not something that's easily achievable yourself. Only after spending years doing similar projects over and over, maintaining them, revisiting them and changing them do you really begin to easily recognize all those common patterns and such. Sure, there are books on enterprise patterns etc. but you can memorize them and still not see the patterns in the actual code (and there are other patterns than just coding ones). Another thing with experience and doing the same stuff over and over is that you can see the pitfalls in advance. You know that you need to do extra bit of coding to prevent code locks, running out of memory, problems with garbage collection in certain situations and you know that before the first line of code is written which saves you a lot of time down the line (when you have to fix code that's been in production for a while and only then the problems start to show up).


i find this an interesting theme brought up in Aldous Huxley's "Brave New World". One can memorize and one can even parrot something and still never actually understand.


“The Nile is the longest river in Africa and the second in length of all the rivers of the globe. Although falling short of the length of the Mississippi-Missouri, the Nile is at the head of all rivers as regards the length of its basin, which extends through 35 degrees of latitude …”

At breakfast the next morning, “Tommy,” some one says, “do you know which is the longest river in Africa?” A shaking of the head. “But don’t you remember something that begins: The Nile is the …”

“The – Nile – is – the – longest – river – in – Africa – and – the – second -in – length – of – all – the – rivers – of – the – globe …” The words come rushing out. “Although – falling – short – of …”

“Well now, which is the longest river in Africa?”

The eyes are blank. “I don’t know.”

“But the Nile, Tommy.”

“The – Nile – is – the – longest – river – in – Africa – and – second …”

“Then which river is the longest, Tommy?”

Tommy burst into tears. “I don’t know,” he howls.)


later in the same chapter...
That howl, the Director made it plain, discouraged the earliest investigators. The experiments were abandoned. No further attempt was made to teach children the length of the Nile in their sleep. Quite rightly. You can’t learn a science unless you know what it’s all about.


https://opentextbc.ca/englishliterature/chapter/brave-new-world-chapter-two/
Ray Kassar To David Crane : "you're no more important to Atari than the factory workers assembling the cartridges"
Manit0u
Profile Blog Joined August 2004
Poland17821 Posts
June 01 2020 16:18 GMT
#20345
On May 31 2020 21:58 JimmyJRaynor wrote:
Show nested quote +
On May 07 2020 19:47 Manit0u wrote:
On another note, I'll have some fun in one side project now. Will be working with C code that was last touched in 1998.

how is it going so far?

I love these types of situations in the software development industry... that is, going through ancient code.


It's going slow. I'm preoccupied with some other stuff so that's mostly a side-project for me. In any case, I've created new structure for the directory with subdirectories and such (previously it was just a mess with everything being in a single directory) and started cleaning it up a bit by removing unnecessary stuff that clogs it up (big chunks of the code were poached from somewhere else and half of it is unused). Once that's done I'll start the real refactoring.
Time is precious. Waste it wisely.
Chocolate
Profile Blog Joined December 2010
United States2350 Posts
June 06 2020 03:07 GMT
#20346
On May 31 2020 21:58 JimmyJRaynor wrote:
Show nested quote +
On May 07 2020 19:47 Manit0u wrote:
On another note, I'll have some fun in one side project now. Will be working with C code that was last touched in 1998.

how is it going so far?

I love these types of situations in the software development industry... that is, going through ancient code.

I've been doing the hermit-coder//"Bob Fitch" thing for several weeks now. A nursing org is replacing/overhauling a Contact Tracing Application made with CA-Clipper in the 1990s. The system's last big update occurred in 2005. It had major upgrades from 1995 to 2005. There is zero documentation. The last programmer who worked on the system is in his 60s. He experienced a major health catastrophe six months ago. I get what info I can from him. He charges the nursing org $200/hour so my time with him is very limited. There is one business analyst still working at the nursing organization that used this application. She has a vague recollection of how the system worked.

My best source of info : Turn on the Tracer and step through the code one line at a time.

Hermit Coder War Stories are the best...

Bob Fitch rescued the Starcraft 1 project by locking himself in a room for several weeks/months and making the SC1 engine.

I've been doing a similar thing for the last two months. I've been tasked with jamming together a project in a very unreasonably short timeline.

I've done the hermit coder thing several times in my career. It has built me some major street cred with project managers and CIOs. Some people can't handle it for whatever reason. I'm an only child and grew up only with my mom. As a child and teenager I had the whole house to myself a lot. So doing the hermit coder thing is right in my comfort zone.

I hear people whine, bitch, moan and complain about "crunch time". Personally, I love it. I'm having a blast.

Show nested quote +
On May 07 2020 03:27 Manit0u wrote:
Unfortunately this is not something that's easily achievable yourself. Only after spending years doing similar projects over and over, maintaining them, revisiting them and changing them do you really begin to easily recognize all those common patterns and such. Sure, there are books on enterprise patterns etc. but you can memorize them and still not see the patterns in the actual code (and there are other patterns than just coding ones). Another thing with experience and doing the same stuff over and over is that you can see the pitfalls in advance. You know that you need to do extra bit of coding to prevent code locks, running out of memory, problems with garbage collection in certain situations and you know that before the first line of code is written which saves you a lot of time down the line (when you have to fix code that's been in production for a while and only then the problems start to show up).


i find this an interesting theme brought up in Aldous Huxley's "Brave New World". One can memorize and one can even parrot something and still never actually understand.

Show nested quote +

“The Nile is the longest river in Africa and the second in length of all the rivers of the globe. Although falling short of the length of the Mississippi-Missouri, the Nile is at the head of all rivers as regards the length of its basin, which extends through 35 degrees of latitude …”

At breakfast the next morning, “Tommy,” some one says, “do you know which is the longest river in Africa?” A shaking of the head. “But don’t you remember something that begins: The Nile is the …”

“The – Nile – is – the – longest – river – in – Africa – and – the – second -in – length – of – all – the – rivers – of – the – globe …” The words come rushing out. “Although – falling – short – of …”

“Well now, which is the longest river in Africa?”

The eyes are blank. “I don’t know.”

“But the Nile, Tommy.”

“The – Nile – is – the – longest – river – in – Africa – and – second …”

“Then which river is the longest, Tommy?”

Tommy burst into tears. “I don’t know,” he howls.)


later in the same chapter...
Show nested quote +
That howl, the Director made it plain, discouraged the earliest investigators. The experiments were abandoned. No further attempt was made to teach children the length of the Nile in their sleep. Quite rightly. You can’t learn a science unless you know what it’s all about.


https://opentextbc.ca/englishliterature/chapter/brave-new-world-chapter-two/

Great post.

Crunch time is my favorite time too. I actually love hitting those weeklong streaks of huge productivity (and usually knowledge/skill) gains and making heads turn. However in a team setting it can work against you if peers get jealous/angry at you for setting higher standards which are admittedly very unsustainable or if managers decide they can squeeze more work out of the team by creating false urgency.

The biggest issue with patterns is as you said, thinking that more applied patterns to code = better code because patterns are in books about writing software. Patterns when misapplied can also make things needlessly brittle or verbose and hard to understand. Even inheritance can be an antipattern.

Lately I've been working a lot with an old-ish piece of cloud infrastructure written in C++ which over time morphed into an uber-dependency ball of mud surrounding a white-hot request path. It has a pattern of applying behavior to the inbound request and outbound response *everywhere*. If you want to make a change, you better get ready to read 100k lines of code, because you'll have no way of understanding how the change will actually impact a request. Sure, there are tests, but only the Old Ones understood the design well enough to test changes coherently (and even so most of the tests are just trivially verifying a boring implementation detail or extraneous behavior - many of which never see the light of day in real use cases, but which are kept around Just In Case), and there's no way to spin up anything remotely resembling an actual prod environment, because it has so many other infrastructural dependencies. I've learned so much of what not to do, or how something which sounds like a good design can degenerate over a decade/dozens of engineers, that it's been a great learning experience.

Biggest takeaway: if you're doing something impressive, it doesn't matter how shitty or unmaintainable your code is as long as it gets you promoted into something that doesn't require you to maintain it. My VP is one of the original authors
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 10 2020 01:49 GMT
#20347
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Acrofales
Profile Joined August 2010
Spain18405 Posts
June 10 2020 06:26 GMT
#20348
On June 10 2020 10:49 WarSame wrote:
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?

I'm not all that familiar with all the AWS services, but there's cloudwatch that you can use to monitor most of them. There's also the log files themselves. And imho your best option is to find one of the clients that is causing the data, and look at what they're doing. Imho looking at what the server is doing or what the client is doing is almost always easier than trying to figure it out from packages on the network. Unless it's actually a network issue.
Silvanel
Profile Blog Joined March 2003
Poland4769 Posts
June 10 2020 08:30 GMT
#20349
Expanded logging is imho the way to go, personally i find it much easier than analysing traffic itself.
Pathetic Greta hater.
JimmyJRaynor
Profile Blog Joined April 2010
Canada17722 Posts
Last Edited: 2020-06-10 08:52:02
June 10 2020 08:40 GMT
#20350
On June 10 2020 10:49 WarSame wrote:
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?

i use West Wind Web Surge.
https://websurge.west-wind.com/

On June 06 2020 12:07 Chocolate wrote:
The biggest issue with patterns is as you said, thinking that more applied patterns to code = better code because patterns are in books about writing software. Patterns when misapplied can also make things needlessly brittle or verbose and hard to understand. Even inheritance can be an antipattern.

lol, yep. when i first wrapped my head around how inheritance worked i created an inheritance anti-pattern. i was just trying to fully understand it so i shoe-horned it in a place it did not belong. For me , it was a solution.. looking for a problem.

regarding anti-patterns ... this book is old, however, imo, it is a timeless classic. you can probably find it for free someplace due to its advanced age. it is fucking hilarious.

https://www.amazon.ca/AntiPatterns-Refactoring-Software-Architectures-Projects/dp/0471197130
Ray Kassar To David Crane : "you're no more important to Atari than the factory workers assembling the cartridges"
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 10 2020 14:01 GMT
#20351
On June 10 2020 15:26 Acrofales wrote:
Show nested quote +
On June 10 2020 10:49 WarSame wrote:
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?

I'm not all that familiar with all the AWS services, but there's cloudwatch that you can use to monitor most of them. There's also the log files themselves. And imho your best option is to find one of the clients that is causing the data, and look at what they're doing. Imho looking at what the server is doing or what the client is doing is almost always easier than trying to figure it out from packages on the network. Unless it's actually a network issue.

Cloudwatch I believe is only used for metrics. It's what I used to tell me why we might be getting some latency for DB access. It showed me we have 2 GB/5 minutes with only a few users online.

I was thinking that too but haven't been able to get DB access as easily as I hoped. I was reading up on it and most replies said that DBs generally have most of their queries saved, which would be helpful, but wouldn't be proof-positive that they are why the replies are so large. I don't know their DB and don't have great connectivity to their team so I was hoping to black box the DB, but I've requested access now. I tried VPC mirroring but after spending ~2 hours reading up on it and setting it up I was just not getting any traffic to my monitoring EC2 instance, so that was frustrating.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
tofucake
Profile Blog Joined October 2009
Hyrule19234 Posts
Last Edited: 2020-06-10 15:37:28
June 10 2020 15:35 GMT
#20352
DB logs have been not so helpful for me, but I'm running Redshift, not RDS. I've had queries running that don't show up in the Running Queries Log.

Try reading this for whatever DB they have running: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.html
it might help...

Otherwise, you'll probably need to do in-DB checks. Postgres has stl_* tables, Maria/MySQL have similar tables, and MSSQL has the same sort of thing but I forget what it's called.

If you have AWS console access to the instance there's a tab for query logs in the cluster panel somewhere.
Liquipediaasante sana squash banana
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 11 2020 03:23 GMT
#20353
The issue is we were interested in which queries were causing such long replies, so just checking the queries wouldn't work(or would, but you'd have to inspect and reason about each individually). I've done traffic mirroring and put the PCAP into Wireshark. I then analyzed the traffic and found that we had a few reasons for so much traffic.

1. Tons of queries per conversation - ~75 queries to display one page to user. This is not a SPA and is stateless so the whole state must be reloaded every time
2. Queries with extra fields - a number of queries are using select * for tables with ~90 fields. Each field is ~100 bytes, leading to 10 KB replies. When you have 75 replies that's quite a lot.

The solutions I've proposed:

1. reduce the number of queries used, use a SPA or something else to reduce it. Long term strategy.
2. don't select *, select the fields you need

This should help reduce the traffic we saw from the DB.

I was also asked to investigate the latency to the DB. I noticed that the conversation took 0.3s for a particular example.

A large part of this was TCP/IP wait/response times. Previously the DB and all servers were on the same machine. They are now on different machines but that requires TCP/IP. Each query runs in serial, so the TCP/IP overhead is added up 75 times.

I have suggested to run these queries in parallel if possible to only suffer the TCP/IP overhead added to the longest query.

Feedback welcome.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Manit0u
Profile Blog Joined August 2004
Poland17821 Posts
Last Edited: 2020-06-11 19:59:21
June 11 2020 19:58 GMT
#20354
On June 11 2020 12:23 WarSame wrote:
The issue is we were interested in which queries were causing such long replies, so just checking the queries wouldn't work(or would, but you'd have to inspect and reason about each individually). I've done traffic mirroring and put the PCAP into Wireshark. I then analyzed the traffic and found that we had a few reasons for so much traffic.

1. Tons of queries per conversation - ~75 queries to display one page to user. This is not a SPA and is stateless so the whole state must be reloaded every time
2. Queries with extra fields - a number of queries are using select * for tables with ~90 fields. Each field is ~100 bytes, leading to 10 KB replies. When you have 75 replies that's quite a lot.

The solutions I've proposed:

1. reduce the number of queries used, use a SPA or something else to reduce it. Long term strategy.
2. don't select *, select the fields you need

This should help reduce the traffic we saw from the DB.

I was also asked to investigate the latency to the DB. I noticed that the conversation took 0.3s for a particular example.

A large part of this was TCP/IP wait/response times. Previously the DB and all servers were on the same machine. They are now on different machines but that requires TCP/IP. Each query runs in serial, so the TCP/IP overhead is added up 75 times.

I have suggested to run these queries in parallel if possible to only suffer the TCP/IP overhead added to the longest query.

Feedback welcome.


Defninitely get rid of stars in your selects. You might also think about adding a cache layer if you fetch the same data often, this would let you avoid the DB queries and round trips.

Another thing that comes to mind is also reducing the number of queries. Maybe you can fetch more data with a single query instead of 5? Also, if you have data overlap between the queries you could look into that.
Time is precious. Waste it wisely.
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 11 2020 23:32 GMT
#20355
They do have a redis cache set up already. Thanks for the great advice! An in-memory cache will be really useful for their more common queries, which should be easily cachable.

They know(and told me when I was starting) that they need to reduce the number of queries but it's a bit of a process. They have a small team so everything takes a while just to work through. I don't think most of their queries are combinable. I think going with SPA might be their best bet for reducing traffic. I know that's on their radar, just going to take a while.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Manit0u
Profile Blog Joined August 2004
Poland17821 Posts
Last Edited: 2020-06-12 21:40:48
June 12 2020 18:05 GMT
#20356
Redis cache is nice but to get some real gains you'd need to look into memcached and stuff like that. Reducing the number of queries is doable even with a small team. I work in a team of 7 people who are responsible for the mission critical elements of multi-million industry and we somehow manage to introduce new features along with doing optimizations and improvements to old stuff.

It all depends on how you approach it, at one point we had ~20% of our sprints reserved for stuff like technical debt reduction, code cleanup etc. Sometimes we even did 100% sprint just for that when we had some more leeway (back-end was ahead of front-end and we had to wait for them to catch up).

Every company handles this differently but if they could do small incremental changes where each one would help even a little bit with not too much effort I think they should go for it. Like, one developer (not entire team) spending one day of a sprint on removing 1 query from the 75 should not be too disruptive and it would eventually lead to more improvements.
Time is precious. Waste it wisely.
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 14 2020 16:26 GMT
#20357
Yeah, I think for them the real answer is to pivot towards more an SPA approach, because that will naturally split up and group their queries, preventing the serial issue. The asterisk issue I think they're willing to spend a significant amount of a sprint or 2 towards which should be all they need.

You need to keep in mind that they are a company with a small team, not just one team of a larger company. They have 5 people, of which only 2 are heavily technical. Your team, I'd imagine is 7/7 tech people, or maybe with one solution owner.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Manit0u
Profile Blog Joined August 2004
Poland17821 Posts
Last Edited: 2020-06-14 19:13:05
June 14 2020 19:05 GMT
#20358
On June 15 2020 01:26 WarSame wrote:
Yeah, I think for them the real answer is to pivot towards more an SPA approach, because that will naturally split up and group their queries, preventing the serial issue. The asterisk issue I think they're willing to spend a significant amount of a sprint or 2 towards which should be all they need.

You need to keep in mind that they are a company with a small team, not just one team of a larger company. They have 5 people, of which only 2 are heavily technical. Your team, I'd imagine is 7/7 tech people, or maybe with one solution owner.


7/7 tech. 2 front-end guys and 5 back-end people (including team leader).

Another tidbit that could help them with removing asterisks and prepare the queries better for the SPA would be creating the views where you have the data aggregated and you query the view instead of actual tables. They don't have to be materialized views, just planning out and creating the views themselves forces you to get rid of asterisks and allows you to cull the columns you don't need.
Time is precious. Waste it wisely.
Manit0u
Profile Blog Joined August 2004
Poland17821 Posts
June 15 2020 12:23 GMT
#20359
https://www.zdnet.com/article/github-to-replace-master-with-alternative-term-to-avoid-slavery-references/

This is seriously getting ridiculous. What's next? All the DBs with master/slave replicas and all the OSs with multiple HDDs?
Time is precious. Waste it wisely.
Nesserev
Profile Blog Joined January 2011
Belgium2760 Posts
Last Edited: 2020-06-15 13:43:39
June 15 2020 13:40 GMT
#20360
--- Nuked ---
Prev 1 1016 1017 1018 1019 1020 1032 Next
Please log in or register to reply.
Live Events Refresh
Replay Cast
00:00
SEL Masters #7
CranKy Ducklings45
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
NeuroSwarm 219
WinterStarcraft216
RuFF_SC2 88
SpeCial 84
StarCraft: Brood War
Rain 3332
GuemChi 2243
Artosis 673
Noble 33
Purpose 21
Counter-Strike
summit1g13101
tarik_tv3455
Fnx 1155
taco 311
minikerr230
adren_tv106
Super Smash Bros
C9.Mang0550
Other Games
Doublelift3260
Day[9].tv811
Maynarde117
ViBE99
Mew2King25
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
[ Show 16 non-featured ]
StarCraft 2
• Hupsaiya 94
• davetesta11
• CranKy Ducklings SOOP8
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• RayReign 11
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Scarra986
Other Games
• Day9tv811
Upcoming Events
Escore
8h 15m
IntoTheTV X SOOP
9h 15m
Big Brain Bouts
14h 15m
DnS vs Rex
Reynor vs Cure
Replay Cast
22h 15m
RSL Revival
1d 7h
herO vs SHIN
Clem vs Solar
Serral vs Rogue
Ladder Legends
1d 16h
Ladder Legends
1d 18h
RSL Revival
2 days
OSC
2 days
OSC
2 days
[ Show More ]
WardiTV Weekly
3 days
The Patches Monday
3 days
Sparkling Tuna Cup
4 days
PiG Sty Festival
4 days
PiGosaur Cup
4 days
Replay Cast
5 days
Kung Fu Cup
5 days
Replay Cast
5 days
The PondCast
6 days
Replay Cast
6 days
Liquipedia Results

Completed

Proleague 2026-08-05
CranK Gathers Season 4: BW vs SC2 Team League
Eternal Conflict S2 Finale

Ongoing

KCM Race Survival 2026 Season 3
K-JUNGMAN
Acropolis #5
Escore Tournament S3: W6
RSL Revival: Season 6
Esports World Cup 2026: LCQ
BLAST Bounty Summer 2026
BLAST Bounty Summer Qual
Stake Ranked Episode 3
XSE Pro League 2026
IEM Cologne Major 2026
Stake Ranked Episode 2

Upcoming

Escore Tournament S3: W7
CSLAN 4
ASL Season 22
Escore Tournament S3: W8
Acropolis #5 - TRS
Blizzard Classic Cup 2026
Acropolis #5 - GSA
HSC XXX
SC4ALL II: StarCraft II
Kung Fu Cup 2026 Grand Finals
PiG Sty Festival 8.0
Big Dog Cup 2026 Div 1
Thunderpick World Champ.
ESL Pro League Season 24
Stake Ranked Episode 4
Logitech G Connect 2026
SL StarSeries Fall 2026
FISSURE Playground #5
BLAST Open Fall 2026
Esports World Cup 2026
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Disclosure: This page contains affiliate marketing links that support TLnet.

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2026 TLnet. All Rights Reserved.