[DiscordArchive] are those queries "all over the place" in ObjectMgr::Load*() methods mostly ?
[DiscordArchive] are those queries "all over the place" in ObjectMgr::Load*() methods mostly ?
Original source
Theres no need to use prepared statements with static WHERE terms.
rektbyfaith
01-04-2021, 02:27 PM #11Archived author: ModoX • Posted: 2021-01-04T14:27:22.751000+00:00
Original source
Theres no need to use prepared statements with static WHERE terms.
Original source
PreparedStatements are mostly used to prevent SQL Injection and in queries where it is obv not possible we must not use them
rektbyfaith
01-04-2021, 02:28 PM #12Archived author: ModoX • Posted: 2021-01-04T14:28:22.616000+00:00
Original source
PreparedStatements are mostly used to prevent SQL Injection and in queries where it is obv not possible we must not use them
Original source
However when a query is executed multiple times prepared statements are a bit faster in terms of performance iirc
rektbyfaith
01-04-2021, 02:34 PM #13Archived author: ModoX • Posted: 2021-01-04T14:34:38.759000+00:00
Original source
However when a query is executed multiple times prepared statements are a bit faster in terms of performance iirc
Original source
Tbh. That is going to be unavoidable and a bit impossible to make all queries be in one place.
rektbyfaith
01-04-2021, 02:49 PM #14Archived author: M'Dic • Posted: 2021-01-04T14:49:03.109000+00:00
Original source
Tbh. That is going to be unavoidable and a bit impossible to make all queries be in one place.
1 Guest(s)
1 Guest(s)