locked
Entity framework performance with mysql RRS feed

  • Question

  • Hi,

    I would really appreciate if anybody can point me to the right direction on how to solve this issue.

    I have the follow query in entity framework. The database in mysql and the ado.net connector is from Devart. It is really slow and most time just timed out. But the same query works fine with mssql. Any body have any suggestions? Thanks in advance.

    (
    from mp in ircontext.ZoomedPixelCoordinateSet
    join c in
    (
    from zp in ircontext.ZoomedPixelCoordinateSet
    where zp.GTileX == gTile.X && zp.GTileY == gTile.Y && zp.Zoom == PointInPolygonZoom
    select new { zp.StateCode, zp.NeighborhoodID, zp.Zoom }
    ).Distinct()
    on new { StateCode = mp.StateCode, NeighborhoodID = mp.NeighborhoodID, Zoom = mp.Zoom }
    equals
    new { StateCode = c.StateCode, NeighborhoodID = c.NeighborhoodID, Zoom = c.Zoom }
    orderby mp.StateCode, mp.NeighborhoodID, mp.SortOrder, mp.OriginalSortOrder
    select new {
    StateCode = mp.StateCode,
    NeighborhoodID = mp.NeighborhoodID,
    TileX = mp.GTileX,
    TileY = mp.GTileY,
    X = mp.GX,
    Y = mp.GY,
    SortOrder = mp.SortOrder
    }
    ).ToList();

    Monday, August 2, 2010 5:59 AM

All replies

  • Hi,

    Since the issue is more related to the 3rd party EF provider for MySQL, I would recommend you consult the issue at the provider related support channel.

    Good day!

    Thanks
    Lingzhi Sun


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Tuesday, August 3, 2010 12:32 PM