The query time shown in the vStudio query builder is wrong

[william humphrey]

Bart

I figured that would be the case (my SQL is uninformative without the
database) but I think the Valentina folks are too busy right now to help
me. I'm going to try and fix the structure of that whole database as  best
I can and see if that helps.

Bill

On Thu, May 17, 2012 at 1:22 PM, Bart Pietercil
<bart.pietercil at cognosis.be>wrote:

>  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
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>
>


-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20120517/31103eb9/attachment.html>