TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ramesh Mahadevan
NA
72
12.7k
SQLite data base takes more timer to run inner join query
Jun 15 2020 8:51 PM
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;
Reply
Answers (
2
)
How to write stored procedure for this problem
Difference between 2 dates in sql.