There is a hot table in the database that is constantly read. How to work with indexes in this case?
Senior
187
Golang
8397
379
Does your team have mobile development?
Senior
187
// Find the maximum even number package main import "fmt" func main() { var max int for i := 1000; i > 0; i-- { go func() { if i%2 == 0 && i > max { max = i } }() } fmt.Printf("Maximum is %d", max) } func maxEvent(n, workers int) int { var wg sync.WaitGroup results := make(chan int, workers) jobs := make(chan int, workers) for w := 0; w < workers; w++ { wg.Add(1) go func() { defer wg.Done() localMax := -1 for num := range jobs { if num%2 == 0 && num > localMax { localMax = num } } result <- localMax }() } go func() { for i := 1; i <= n; i++ { jobs <- i } close(jobs) }() go func() { wg.Wait() close(results) }() globalMax := -1 for localMax := range results { if localMax > globalMax { globalMax = localMax } } return globalMax }
Middle
187
What non-standard situations can occur during booking and how to handle them?
Middle
187
What are the features of the Go language compared to other programming languages?
Junior — Middle
186
What synchronization methods do you know in Go?
Middle+
186
What criteria do you use to select companies, what do you focus on?
Middle+
185
Is there a way to manage and tune the stop-the-world garbage collector in Go?
Middle+
185
Have you measured the RPS of services?
Middle
185
Does the size of the channel buffer affect anything in a worker pool?
Senior
183
What tasks have you been involved in on the project from your side?
Middle+
183
How to monitor the correctness of the system operation (monitoring)?
Middle
183
After fixing something, what else do you do?
Senior
182
How does the seat reservation mechanism work at the database level? How to ensure that a seat is not sold twice?
Middle
182
What happens when you append if the slice's capacity is insufficient (allocating a new array)?
Middle
181
How to implement message sending in a gRPC service?
Junior — Middle
181
If there are 500-1000 URLs, will all GET requests be executed in parallel?
Senior
179
What are interfaces in Go? Why are they needed? How are they implemented under the hood?
Middle
179
How many services read the Kafka topic?
Senior
178
Tell us about indexes in databases: why they are needed, what types exist, and how to choose them correctly.
Senior
177