<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On May 17, 2012, at 8:07 PM, william humphrey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">I have this query
<div><br></div><div><div>SELECT distinct t_family_name,t_given_name,p_description,v_shipID, tripulantes.tripulanteID FROM tripulantes </div><div>LEFT JOIN linktripulantes on Link_tripulantes_linktripulantes</div><div>LEFT JOIN positions ON Link_positions_tripulantes </div>
<div>left join voyages on linktripulantes.voyageID = voyages.voyageID</div><div>WHERE v_shipID = '150' AND tripulantes.t_pax <> '1';</div></div><div><br></div><div>It is on about 4000 records and I don't know enough about SQL and Valentina to make a link for the "linktripulantes" which is a link table itself that was brought in from when this database was converted from SQLite to Valentina</div>
<div><br></div><div>This query takes 1 minute 15 seconds timed with my stop watch. It takes about 1 minute 20 seconds. It took longer than that until I converted some of the text fields to varchar. </div><div><br></div><div>
But what I'm reporting is that the Query time shown is vStudio is 321 milliseconds. I just wish that were true.</div><div><br></div><div>Anyone have any suggestions for me to try to speed this thing up?</div></blockquote></div><div><br></div>Actually you see the time spending in parsing SQL, building the tree and execute that node tree - up to resulting cursor is ready.<div><br></div><div>After that, vStudio shows first records of that cursor - it seems this operation takes the rest of time.</div><div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div>-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div></span>
</div>
<br></div></body></html>