SQLite data base takes more timer to run inner join query

in the below query i'm returning only 50 rows but it is taking 15sec to execute. Index are already used.

any help?

SELECT WP_TimerName, WP_WeldJobName, WP_Comment, WP_SpotName, WP_WeldJobVersion,
WP_LogNo, WP_TipWearCount, WP_TipDressCount, WP_UnixEpoch, WP_uirModeOff, WP_MonitorState, WP_MonitorErrorCode, WP_SpotRepetition,
WP_GhostRunMode, WP_GunName, WP_GunResistance, WP_TimerId, WP_CurrentMeasurementState, WP_VoltageMeasurementState, WP_ForceMeasurementState,
WP_PositionMeasurementState, WP_ContactWaitTime, SBP.Id SequenceBlock_Id, BP_SequenceBlockNo, BP_ForceOffset, BP_OffsetPosition, BP_SequenceBlockType, BP_UIP,
BP_FQF, BP_MeanCurrent, BP_MeanForce, BP_MeanPosition, BP_MeanPulse, BP_MeanResistance,
BP_MeanVoltage, BP_RegulationMode, BP_Energy, BP_GunResistance, WP_STCReference, WP_STCTeachName, BP_UIP, BP_CurrentCurve,
BP_VoltageCurve, BP_ForceCurve, BP_PulseCurve, BP_PositionCurve, BP_ScheduledBlockNo, BP_Length, BP_PSF, BP_spatterTime,
BP_TypeOrderNo , WP_ForceSensorScalFactor3 , WP_ForceSensorScalFactor2 , WP_ForceSensorScalFactor1 , WP_ForceSensorScalConstant ,
WP_PositionMeasurementState , BP_OffsetPosition ,BP_MeanPosition ,BP_PositionCurve ,BP_ReferenceCurveLength ,
BP_MonitorStdActualValue ,BP_MonitorStdReferenceValue ,BP_MonitorStdUpperToleranceBandPerc ,BP_Indentation ,BP_MonitorStdLowerToleranceBandPerc ,
BP_MeanTorque,BP_PQF
FROM WeldProtocol_Log_T WP
INNER JOIN
SequenceBlockProtocol_Log_T SBP
ON WP.Id = SBP.BP_WeldProtocol_Log_T_Id
WHERE 1=1
AND ((BP_SequenceBlockType=1 AND BP_TypeOrderNo=1))
ORDER BY
WP_UnixEpoch DESC,
WP_LogNo DESC
LIMIT 50 OFFSET 117050;

2 Replies

Know the answer? Post it — somebody with the same question will find it here.