[TomBez]

peterlaursen wrote on Sep 17 2006, 04:10 AM:

and with a stop button …

and what should a stop-button actually do? stop the query when you forgot to uncheck “Show all”? if yes than a big ++ for that 🙂

another possibilty would be, autofetching rows, when scroll down to the end (a smarter way and you won't need so many buttons).

[TomBez]

peterlaursen wrote on Sep 15 2006, 01:57 PM:

1) you should use a non-proportional font (like Courier) – it looks like Arial …

.. a series of SPACEs do not take much SPACE for instance …

That will do the trick if column names are not too long.

a different solution would be, to put the datacells into a html-table. depends on what gui-framework you use. (split values with regexp)

[TomBez]

DARAB wrote on Sep 9 2006, 08:05 PM:

are the database engines on both machines the same? it looks like a bit like you would use INNO-DB for your laptop and myisam on the slower machine.

INNO-DB for both.

I think it is a problem of indizis, looks like to me that on the slower machine they are deactivated during bulk insert and on the faster machine they are activated.

[TomBez]

jack111 wrote on Sep 7 2006, 11:27 AM:

YOU NEED TO MAKE THE SQLyog interaction more user friendly

For my needs SQLyog is much more userfriendly than navicat f.e. but this is maybe because i do come from the oracle corner and I'm used to the tools used there (and don't call them userfriendly 😉 the plain old sql-client from oracle is simply a pain compared to sqlyog).

If you expect from a tool, that you have more a ms-access point of view to something like a database, you might be happier with navicat. from the view of database administrator you won't be happy with navicat.

the support from the developers you find in the forum and with the ticket system is something you won't find very often, even if you pay a lot of money for support. i haven't seen microsoft or oracle making patches within 2 days for a bug found.

[TomBez]

jack111 wrote on Sep 7 2006, 09:35 AM:

Navicat so far is much quicker, smoother and easier to understand and execute.

It's maybe a question of taste, but those enormous amount of windows you have to pop up in navicat are anoying me. people like me, who have at least 10 applications run at the same time dont want to have a taskbar that needs 3 rows just for the sql-application to switch between windows (I hate that also with gimp or ms office) and turning of that they are in the taskbar means, that you have to search for your windows, which is even %$&$&$.

from the performance point of view it's pretty much the same.

I'm a user not sqlyog-guy

[TomBez]

DARAB wrote on Sep 5 2006, 05:50 PM:

I have changed the “Max Packet Size (in K:cool: for BULK INSERT statements” on the General tab of Preferences in SQLyog to 10000. I ran the import again and it has ben running for over 12 hours and it looks like it has 4-6 hours to go. This same import took 35 minutes on a slower machine. I've compared the my.ini files between the 2 machines and if there are differences, my machine that is taking such a long time to import has higher settings. The version of MySQL on the machine that imports in 35 minutes is a slightly older version and is an alpha. Could there be a different MySQL file that has parameters I need to change?

do the databases use different charsets?

what happens if you set your my.ini settings to the same values as the slower machine has?

does the slower machine have a raid-disk-subsystem (or something like a cache-controller)?

are the database engines on both machines the same? it looks like a bit like you would use INNO-DB for your laptop and myisam on the slower machine.

[TomBez]

Martin Larsen wrote on Sep 5 2006, 11:30 AM:

Whoa.. I was not aware that I_S is that slow.

Code:

mysql> select count(*) from tables;
+———-+
| count(*) |
+———-+
| 88061 |
+———-+
1 row in set (2 hours 2 min 45.43 sec)

That is totally unacceptable. 😮

My thougt was that if I_S was “fast enough” it was worth a tiny amount of smaller performance to skip the tags files totally. My guess is that it would make the logic behind autocomplete much simpler.

But to compare the changed times from the tags files with the changed time in I_S would be great. Lets just not hope the I_S slownes outweighs the improvement. 🙂

select count(*) from tables;

198

547 ms

that would be quite fair. problem might be, that there isn't any index on that table, dont know if this would be possible for the memory-engine

[TomBez]

larsen wrote on Aug 30 2006, 12:49 PM:

Developing an application or website on another machine than the production system. This way it would be easier to create (copy) the appropriate user and privileges on the production system.

And what would happen, if you have tables in production that you don't have in developement and vice versa? getting a permission error afterwards would make most people think, that this is a sqlyog bug.

btw: at least and passwords should differ from developement to production 😉

[TomBez]

peterlaursen wrote on Aug 16 2006, 12:08 PM:

I data shall be SYNC'ed with SQLyog it is not alwas a good idea to have a auto-icrement PK.

Even the 'smartest' database experts disagree on that!

Maybe it is because I had to often build a lot of functionality around a natural key which didn't worked as designed, sometimes the real world changes, so that adoptions in den schema itself have to made, with surrugate keys less of them have to be made, but thats only my experience.

peterlaursen wrote on Aug 16 2006, 12:08 PM:

I think you coul JOIN the table to itself as well.

One day when I get the time I will study joins in details!

I'm not sure if mysql supports selfreferencing like oracle. i haven't found any “connect by” clause in the documentation. a statement like “select mytable1.* from mytable mytable1, mytable mytable2 where mytable1.column1>10 and mytable2.column1<3" is possible and works

[TomBez]

peterlaursen wrote on Aug 14 2006, 07:05 PM:

Code:

select magasin,article_nt, date_tarif , marge_theo from tar where date_tarif in (select max(date_tarif) from tar group by article_nt);

this can be very slow on large tables, avoiding “select .. from .. where … in (select)” is for larger tables very usefull especially if you can expect to get a lot of values from the “in (select)” or if you have an order by/group by in the “in(select)” statement.

peterlaursen wrote on Aug 14 2006, 07:05 PM:

PRIMARY KEY (`MAGASIN`,`ARTICLE_NT`,`DATE_TARIF`)

in my opinion primary keys should always be autoincrement values and never the natural key. if you need it, use a unique key or create a trigger for that. as the application might get older, you will maybe notice that your natural key isnt unique anymore and changes of the primary key do harm to the whole E/R-modell.

[TomBez]

This is because you select not a certain row (the row where the value of max(column) occures you should select), therefore he takes the value of the first row and the value for max(column) from the row where it occures.

[TomBez]

peterlaursen wrote on Aug 3 2006, 11:49 AM:

I wonder if CPU load is very high due to other tasks running?

cpu load is low. have you tried it with InnoDB as storage engine? (i can provide testdata if you need). I'm using sqlyog 5.15

[TomBez]

peterlaursen wrote on Jun 7 2006, 06:35 PM:

What editor do you use that has this feature?

there are a lot of editors with this feature, every editor with sql-synthax highlighting. brackets in general they nearly all understand (of cause not notepad, but ultra edit, pspad, jedit, etc).

[TomBez]

Donna wrote on Jun 8 2006, 12:29 AM:

Your example above is one. Just today a developer asked me if I know a way to script just a couple stored procedures. She'd been working on her laptop at home and now wanted to integrate them into the development database. They include new stored procedures and modifications to existing stored procedures…and before she makes those changes I want to be able to back up the existing stored procedures just in case!

this is why there are numerous version control systems on the market 🙂

[TomBez]

peterlaursen wrote on Jun 4 2006, 09:22 PM:

Hello Tom …

I am not sure that I understan you. But this is planned

1) A 'filtering' opton

2) A 'Select All' + ' Deselect All'

3) CTRL+CLICK and SHIFT+CLICK for easy selection of large no.s of rows

Is it something like this?

hi peter,

yes something like this, or more .. exactly like this :).

regards

[Author]

Posts