Published on (UTC)
This post was submitted by a user and reflects their personal experience or opinion. The publication date is not an employment or interview date.
No particular advantages
The interview process involved many technical questions. The technical manager’s questions were somewhat repetitive, repeatedly asking: if the database is slow because of the large volume of data, how should it be handled? I suggested solutions such as indexing, splitting tables, JOINs, limiting the number of records retrieved, modifying SQL syntax, and distributing requests across servers to retrieve the data. However, the manager kept repeating that indexes had already been created and the number of records was already limited, then asked, “What other ways are there?” I did not really understand how this manager defined a large volume of data. In the end, the manager glossed over the issue, leaving its meaning unclear.