The query time shown in the vStudio query builder is wrong

[Bart Pietercil]

without knowing the table structure and links between the tables not much sense. Probably the best thing to do is putting the db somewhere available and post a download link. 

regards 

-- 
Bart Pietercil
CTO Cognosis NV
Dorpstraat 28
3560 Lummen


On Thursday 17 May 2012 at 19:07, william humphrey wrote:

> I have this query 
> 
> SELECT distinct t_family_name,t_given_name,p_description,v_shipID, tripulantes.tripulanteID FROM tripulantes 
> LEFT JOIN linktripulantes on Link_tripulantes_linktripulantes
> LEFT JOIN  positions ON Link_positions_tripulantes 
> left join voyages on linktripulantes.voyageID = voyages.voyageID
> WHERE v_shipID = '150' AND tripulantes.t_pax <> '1';
> 
> 
> 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 
> 
> 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. 
> 
> But what I'm reporting is that the Query time shown is vStudio is 321 milliseconds.  I just wish that were true.
> 
> Anyone have any suggestions for me to try to speed this thing up? 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net (mailto:Valentina-beta at lists.macserve.net)
> http://lists.macserve.net/mailman/listinfo/valentina-beta
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20120517/91780adb/attachment.html>