Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sudden decrease in MySQL perfomance
All Just a case of being stoopid on my part..nothing wrong with MySQL...:) In the destination table..I had created a control field which I used to determine which records had been written across so that I could delete them from the source tables... I then used a script which counted the... -
Sudden decrease in MySQL perfomance
Hi Sleipnir The indices on the source tables are currently set on each of the columns referenced in the predicate of the query. We've tried increasing the env variable for MySQL that covers bulk inserts...its name escapes me at the moment, but doubling it has made precious little difference -
Sudden decrease in MySQL perfomance
Hi sleipnir Thought of that, and have stripped the destination table of all indices (incl PK)- made the query a little faster but it still exhibits the same pattern. The indices on the source tables should not affect an "INSERT...SELECT" query.....or am I wrong? -
Sudden decrease in MySQL perfomance
Hi All My problem is as follows: I am currently running a PHP application that has a MySQL backend (Apache & PHP are on a seperate server to MySQL which is on a dedicated box - P4, 1.6GHz, 512MB RAM, OS: Linux). Part of the application merges data from approximately 900 tables in one DB... -
Referring to one object from within a method of anotherobject
OK..tried it and the code I was asking about in my original post does work...only took me about five minutes to dummy up....laziness never prospers. R -
Referring to one object from within a method of anotherobject
Nope. Being lazy I guess, was just hoping that it would take less time to get an answer than to knock together a test case, but ( insert dramatic_sigh_of_overworked _and_underpaid_person.wav here) I guess it looks like the latter course is becoming necessary. R -
Referring to one object from within a method of anotherobject
I have a script where I have two objects of two different classes, call them Object A and Object B. Object A has a method called Method_A and Object B has a method called Method_B. When I initialise Object B, I pass a reference to Object A and assign it to $Object_A. So far so good.However, now... -
Accessing MySQL Db connection from within a function
This is probably a really newbie question, but I can't search tek-tips at the moment, so I am going to have to post it. I am writing a script where I establish a connection to a mysql db server within the main body of my script. Later I call a homemade function that runs a query via the already... -
Quick one - how can i tell if an integer is odd or even?
Hi Dave I am a newbie to PHP (total time 1 day) so I will not be able to give you the PHP code, but in Cold Fusion there is a mathematical operator that I think is fairly common to most languages (and I would imagine is available in PHP), namely modulus. Modulus gives you the remainder and... -
Problems importing text files
Thanks KarveR I was doing that, but it didn't help. My text field was exactly like your example, but I found that if I didn't use the enclosed by parameter, the problem went away (even though the fields are enclosed by ").I will post the issue under a new thread, but I just need to have to... -
Problems importing text files
Hi all This is probably a newbie question, but seeing as that's what I am, please bear with me. I have a file that I need to import (comma-seperated variables) into a MySQL table. There are three fields, two of which are arbitrary, and one in which I am interested. The field I am interested in...
