You will no longer receive e-mail notifications from this forum.
Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
I have 2 desktop computers. One is over 10 years old, fairly low powered 4gb memory, the second is a new Intel I7 7700K
with 32gb of memory. Both are running the same Toad version.
I have a DB containing about 30 million records.
On the old PC, doing a simple select take 0.23 seconds
The same select on the same DB on the new machine takes over 82 seconds?
Any ideas what might be going on? I may have made some Toad setting change on the older PC, but
darned if I can think of what it may be.
Any ideas why it is running so slow on this otherwise quite powerful PC?
Is there no way to scope the Schema Compare to look for real differences and not auto increment differences?
Besides the fact that schema compare is hicking up and finding differences when there are none...
What is necessary for me is to find different datatypes, missing columns etc - this is what happens when developers (or customers) go crazy or customer installations need an update after a couple of years.
Basically an "omit: with a list of checkboxes such as ENGINE; AUTO_INCREMENT and so on.
ENGINE = InnoDB
AUTO_INCREMENT = 83038
CHARACTER SET = latin1
ROW_FORMAT = DYNAMIC;
AUTO_INCREMENT = 29412
CHARACTER SET = utf8
ROW_FORMAT = COMPACT;
Good day everyone,
I was wondering if it is possible to re-order the output of the script that gets generated when doing a data comparison of two databases... I always find myself having to manually intervene to re-arrange the order in which the query gets executed so it doesn't result in errors.
This is usually due to the foreign key exceptions where a table that relies on data that has not yet been imported (Because it's lower down in the script because of the alphabetical order the tables get arranged in) breaks the smooth execution of the import.
Please let me know if this is possible without dropping and recreating keys.
고고티켓만의 자신감 1800-4840 go1800 문화상품권1. 고객만족 1위업체 고고티켓2. 재방문 1위업체 고고티켓3. 지인소개 1위업체 고고티켓
고고티켓만의 캠페인 1800-4840 go18001. 안전한 거래 2. 친절한 상담3. 신속한 처리
모바일상품권전문 [고고티켓] 1800-4840 go1800 1. 상품권매입 상품권현금화 상품권현금교환 상품권현금으로2. 모바일상품권 온라인상품권 원스토어상품권 카카오톡상품권 2. 문화상품권 해피머니상품권 도서문화상품권 3. 모바일티머니 모바일캐시비 모바일엠틱 OK캐쉬백 오케이캐쉬백 네이버캐시4. 그외 결제관련문의상담고고티켓만의 추가혜택 20이상시
고고티켓 상품권매입 상품권현금화 상품권현금교환 상품권현금으로 모바일상품권매입 모바일상품권현금화 문화상품권매입 문화상품권현금화 문상매입 문상현금화 해피머니상품권매입 해피머니상품권현금화 해피머니매입 해피머니현금화 도서문화상품권매입 도서문화상품권현금화 도서상품권매입 도서상품권현금화 네이버페이현금화 모바일티머니현금화 모바일캐시비현금화 모바일엠틱현금화 OK캐쉬백현금화 소액결제현금화 휴대폰결제현금화 핸드폰결제현금화 모바일결제현금화 아이폰결제현금화 구글결제현금화 드라마무료다시보기 최신영화정보 파워볼 경마결과 #고고티켓 #상품권매입 #상품권현금화 #상품권현금교환 #상품권현금으로 #모바일상품권매입 #모바일상품권현금화 #문화상품권매입 #문화상품권현금화 #문상매입 #문상현금화 #해피머니상품권매입 #해피머니상품권현금화 #해피머니매입 #해피머니현금화 #도서문화상품권매입 #도서문화상품권현금화 #도서상품권매입 #도서상품권현금화 #네이버페이현금화 #모바일티머니현금화 #모바일캐시비현금화 #모바일엠틱현금화 #OK캐쉬백현금화#소액결제현금화 #휴대폰결제현금화 #핸드폰결제현금화 #모바일결제현금화 #아이폰결제현금화 #구글결제현금화 #드라마무료다시보기 #최신영화정보 #파워볼 #경마결과
고고티켓만의 자신감 1800-4840 go1800 모바일상품권 온라인상품권1. 고객만족 1위업체 고고티켓2. 재방문 1위업체 고고티켓3. 지인소개 1위업체 고고티켓
고고티켓만의 자신감 1800-4840 go1800 네이버페이포인트1. 고객만족 1위업체 고고티켓2. 재방문 1위업체 고고티켓3. 지인소개 1위업체 고고티켓
고고티켓만의 자신감 1800-4840 go1800 캐쉬백1. 고객만족 1위업체 고고티켓2. 재방문 1위업체 고고티켓3. 지인소개 1위업체 고고티켓
고고티켓만의 자신감 1800-4840 go1800 모바일캐시비1. 고객만족 1위업체 고고티켓2. 재방문 1위업체 고고티켓3. 지인소개 1위업체 고고티켓
고고티켓만의 자신감 1800-4840 go18001. 고객만족 1위업체 고고티켓2. 재방문 1위업체 고고티켓3. 지인소개 1위업체 고고티켓
A new version of Toad for MySQL has appeared in the downloads (184.108.40.2060) - as far as I can tell there was no beta, no announcement, and there does not appear to be any updated documentation or release notes. There is also a link on the Toad for MySQL page to the free preview of Toad Edge suggesting that Toad for MySQL will eventually be replaced by Toad Edge (or maybe I'm reading too much into that) - I'm assuming that Toad Edge will ultimately be a paid product, it's just a free preview? Can someone from Dell/Quest please update the info to reflect the latest version and also clarify the future for Toad for MySQL.
in Toad for MySQL 220.127.116.110 (64bit) i have error message "Unable to connect to any of the specified MySQL hosts." when trying to connect to all of my MySQL servers (VPS or local).
In version 18.104.22.1687 everything works fine.
Please help, i want to use ver.8.0 because of Git support.
I'm pretty sure this bug was introduced in the latest release (22.214.171.1240). After running a query the first row in the grid is selected, now if I click a single cell in the first row the whole row stays selected, so if I now copy I get the entire row instead of only the cell I clicked. The only way I have found to unselect the whole row is to first click a cell in another row, or use the arrow keys on the keyboard to move to a different cell.
Tried formatting stored procedure code which has a query with "LIMIT v_param1,v_param2" syntax, and it breaks because of the variables.
Using Toad for MySQL 126.96.36.1997
first of all i want to thanks to Toad team for adding Git support to Version Control Sysytem.
I have a question, does Toad support commands like Push,Pull directly from Version Control system or i still need external tool ?
One time, when i tired several Toad and Git configs i saw this commands in Version Control System menu, but now i cant simulate it again.
Was it some kind of bug or Toad really know that ?
Using Toad for MySql 188.8.131.520 (64bit)
Change config resource settings from zero when I installed MySQL 5.7 now can't find how to change them back to default. Tried reinstalling no change even after I thought I had removed all sql apps.
Only information i have is an URL for "phpMyAdmin" and I do have access to this link.
Please help me.
Is there an update on https://www.toadworld.com/products/toad-for-mysql/f/22/t/31142 i.e. JSON data type support in Toad ?
I required this support and searched on the forums.
From post https://www.toadworld.com/products/toad-for-mysql/f/22/p/31978/64241#64241 identified link http://community-downloads.quest.com/toadsoft/MySQL/ToadForMySQL_Beta_184.108.40.2065.zip
Tried installing this but it fails with an installer option to choose "Uninstall Toad for MySQL beta and continue with install" and "Uninstall Toad for MySQL beta only" required.
Tried both neither works. Funnily have never installed Beta earlier. So uninstalled existing Toad for MySQL still the installer didn't allow me to proceed throwing up the same screen.
After a bit of searching got this link https://www.toadworld.com/m/freeware/1612/download to register and download a new installer
Unfortunately India is not listed in the country options hence unable to download.
Any suggestions ? I am able to work using MySQL Community Workbench but would much rather Prefer TmSQL
I'm trying to get a database into version control and all the database objects are showing a status of "uninitialized". I think I must be missing a step, but there doesn't seem a way to commit, check in, or check out anything to get it into version control. The Perspective screen doesn't list any objects.
Running Toad for MySQL 220.127.116.117 and svn version 18.104.22.1680. Connections to the repository with this version work fine, the "Try Login" on the version control configuration screen returns the green check mark.
Let me know if anybody has ideas for resolution.