Filter interviews by
Optimizing PHP and MySQL queries involves using indexes, optimizing queries, and reducing data transfer.
Use indexes to speed up data retrieval
Optimize queries by avoiding unnecessary joins and subqueries
Reduce data transfer by selecting only necessary columns
Use caching to avoid repetitive queries
Avoid using SELECT *
Use EXPLAIN to analyze query performance
Top trending discussions
I applied via Approached by Company and was interviewed in Aug 2021. There were 3 interview rounds.
Assignment to develop a prototype
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Will be given Requirement to write code for Restraunt. Based on that have write code for delivering orders by delivery boys.
posted on 7 Jun 2024
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
Use dynamic programming to find the shortest path sum with negative integers allowed in a matrix.
Implement dynamic programming to store the minimum sum at each cell
Consider negative integers when calculating the sum of the path
Start from the top left cell and iterate through the matrix to find the shortest path sum
posted on 26 Jul 2024
Spring code is used for building Java applications with ease and efficiency.
Use @ComponentScan annotation to automatically detect and register Spring beans
Use @Autowired annotation for dependency injection
Use @RequestMapping annotation to map HTTP requests to specific handler methods
I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.
I applied via Recruitment Consulltant and was interviewed before Feb 2022. There were 3 interview rounds.
Find the longest palindromic substring in a given string.
Use dynamic programming to solve the problem efficiently.
Start with the base cases of single characters and two characters.
For longer substrings, check if the first and last characters match and if the substring between them is also a palindrome.
Keep track of the longest palindrome seen so far.
Time complexity: O(n^2), space complexity: O(n^2).
Developing a real-time data processing system for a high-traffic website.
Designing a scalable architecture to handle the high volume of incoming data.
Optimizing the data processing algorithms to minimize latency.
Ensuring data consistency and accuracy in a distributed system.
Implementing fault-tolerant mechanisms to handle system failures.
Testing and debugging the system under various load conditions.
posted on 7 Feb 2024
I was interviewed in Aug 2023.
Optimizing build in Angular involves reducing bundle size, enabling lazy loading, using AOT compilation, and leveraging tree shaking.
Reduce bundle size by removing unused code and optimizing imports
Enable lazy loading to load modules on demand instead of all at once
Use Ahead-of-Time (AOT) compilation to pre-compile templates and reduce runtime overhead
Leverage tree shaking to eliminate dead code and reduce bundle size
posted on 26 Aug 2024
based on 1 review
Rating in categories
Sales Manager
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Sales Associate
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate Operations
3
salaries
| ₹0 L/yr - ₹0 L/yr |
AVP Finance
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Shiprocket Private Limited
Delhivery
Ecom Express
Shadowfax Technologies