#mysql - Thu 17 May 2007 between 00:28 and 01:14

NY Lost Funds



seekwillI don't know InnoDB very well
Sashik
threnodySashi: database engine choice is a per table decision. Even within a single database.
seekwillTrue!
T`hmm i see in select * from table; that sid col is NULL, but doing a select * from table where sid = NULL; gives empty lis
list
actually nm.. "where sid is NULL" works
seekwill:)
garotosopaIs it ok to have everything in a innodb table with a pseudo foreign key to a myisam table so I can use fulltext search? and a trigger in first to pseudo delete cascade the correspondent in the myisam? is it common?
seekwillIt's not a psedu FK. It's just not enforced.
A FK is more of a theory. It's not a function/feature
Enforced FK is a function/feature
garotosopayeah I meant in the sense of strict
seekwillI think a trigger will work for the cascade. Never tried it though
garotosopaI guess that it wouldn't work if the delete in innodb table was going to be cascaded too (like delete author -> cascade articles -> trigger to delete myisam). but it's my the case.
do you see any problem with this?
seekwillYeah
garotosopa(I mean "it's *not* the case)
would you suggest to use myisam only? or not to use fulltext at all?
seekwillTry it
Probably not use FTI
savagephpIs there a limit on the number of queries per unit time that can be sent to mysql?
Practically I mean...
seekwillWhat unit of time?
savagephpuhh...matter of seconds
seekwillEach query uses a different connection. The number of concurrent connections depends on your hardware
savagephp5 seconds
seekwillAnd the type of queries, how long each one will last.
savagephpWell, I'm just sending a bunch of basic inserts from php
seekwillMost likely you are inserting one at a time. How many is a bunch?
savagephpBut I'm trying to send 125,000 of them just as fast as it can process
It craps out at around 350'ish
seekwillWrite them to a CSV text file and use LOAD DATA INFILE
MUCH faster.
savagephpMySQL just seems to lock up and won't respond for a while
hmm
seekwillThat's sort of odd actually.
savagephpI can't use a CSV file, commas are a valid character in a number of the fields
seekwillThen use another delimiter
You can use quotes around your strings ;)

Page: 3 10 17 24 31 38 45 52 59 

IrcArchive

NY Lost Funds