[carltond]

I can also confirm that the enterprise edition that I am using no longer causes an increase in memory when I resize the application window repeatedly…the memory usage stays at around 6000K-8000K even if I repeat the query across differet tabs.

Well done 😀

[carltond]

vygi wrote on Jan 5 2006, 04:04 PM:

@Ritesh: you have one as well  😛

[post=”8375″]<{POST_SNAPBACK}>[/post]

Yep one from me too…It was asking me to reg the program unfortunately 😮

[carltond]

Ritesh wrote on Jan 4 2006, 02:21 PM:

OK, we are back in action  😀

We are now working on a similar memory related issue while importing millions of data using Migration Toolkit. Once fixed, we will start working on this one.

Rest assured, 5.02 FINAL will have the bug fixed.

[post=”8361″]<{POST_SNAPBACK}>[/post]

That's nice to hear…thanks 😀

[carltond]

Well let's just hope the problem (as minor as it is really) can be fixed…great program though! Thumbs up so far

[carltond]

peterlaursen wrote on Dec 30 2005, 04:07 PM:

@carltond: what is your Graphics?

[post=”8326″]<{POST_SNAPBACK}>[/post]

From what I can see graphics card is…

Intel ® 82915G Express Chipset Controller, 128MB…it's a work PC so pretty crap card I think.

CPU is 3.2 Pentium 4 though with 1GB RAM which is pretty good.

[carltond]

vygi wrote on Dec 30 2005, 03:15 PM:

Would be interesting to know if same hapens on carltond's (originator of this thread) machine.

[post=”8320″]<{POST_SNAPBACK}>[/post]

Hey, I've still been watching this thread but haven't replied due to that I was asked for data to work with and as it's company data and individual's can be identified by it I wasn't interested in sharing it (for data protection reasons).

However I have managed to recreate the problem.

It seems to stem from along query…I generated the initial problem with this query

Code:

SELECT mysqlCustomer.*, Parent.HO_NO AS PARENT FROM mysqlCustomer LEFT JOIN mysqlCustomer AS Parent ON mysqlCustomer.CLIENT = Parent.CLIENT WHERE mysqlCustomer.HO_NO IN (SELECT mysqlCustomer.CLIENT FROM mysqlCustomer LEFT JOIN mysqlCustomer AS Parent ON mysqlCustomer.CLIENT = Parent.CLIENT WHERE mysqlCustomer.HO_NO IN (SELECT mysqlCustomer.CLIENT FROM mysqlCustomer LEFT JOIN mysqlCustomer AS Parent ON mysqlCustomer.CLIENT = Parent.CLIENT WHERE mysqlCustomer.HO_NO IN (SELECT mysqlCustomer.CLIENT FROM mysqlCustomer LEFT JOIN mysqlCustomer AS Parent ON mysqlCustomer.CLIENT = Parent.CLIENT WHERE mysqlCustomer.HO_NO IN (SELECT CLIENT FROM mysqlCustomer WHERE (DATE(NOW()) < DATE_OFF OR DATE_OFF = '0000-00-00') AND (CLIENT > 5000 AND CLIENT < 6000) AND CODE !='')))) AND mysqlCustomer.CODE = 126728 ORDER BY CODE

The query takes a second and returns 159 rows from 6000+ records.

Then as vygi suggests if you resize the window (I double clicked the application toolbar at top of screen to restore and then maximize) and the mem usage increases by 1500 – 2500k each time, more so when the window is maximised.

However when I minimise the window mem usage shoots DOWN to 800k or something minor. I can then follow the maximise/restore procedure and it all happens again.

I can't really restart my comp at the moment cos I should be cracking on with work but will check it on tuesday and see how it handles small queries because at the moment even a select * query returning 6000 records increases the mem usage by a similar amount 😮

Hope that helps identify the issue, this slowdown issue hasn't been a problem of late because I am working on slightly smaller queries…it may be this large query that starts SQLYog struggling.

I love this prog…over things like phpMyAdmin and Query Browser so will defo stick with it anyway.

I would love to see the history sent to a file, as I am testing loads at the moment I want to keep my queries but find myself having to manually save them to a text file which is annoying but would be good if it could be done automatically

[carltond]

Ritesh wrote on Dec 21 2005, 03:21 PM:

How many rows does the query return?

Are you sure the query is proper i.e. indexes are correctly used? It might be that the MySQL client library needs to create lot of data at the client side to create the correct resultset for your query.

Personally, I believe its a query problem rather then SQLyog.

[post=”8247″]<{POST_SNAPBACK}>[/post]

The query only returns 1000 rows and at the moment I am trying to fine tune my query so I am submitting a similar query each time with a few minor changes

[Author]

Posts