10-01-2009
1. Multithreading means "you must be stupid to do this in shell"
2. Loading 1 huge set of data at once is in general faster than loading dzylion of microsets in parallel
3. In Oracle you have SQLLoader and it has mode called "direct" - check if you cannot use similar thing in MySQL (I have no experience in MySQL)
4. If there is no option of direct loading of the data you might want to use bulk load methods
5. Loading in multiple threads means that you most probably are going to create dzylion of connections... if creation and closing of a single connection takes 1 second and inserting 1 row of data takes 0.0000000001 of a second... imagine how much slower would it work if you create multiple threads
6. Transaction is your friend - until you commit your application (executable compiled application) should be able to insert rows with only a minor performance decrease - if this is really really required by you then you might assume that there is a probable chance that you might need to create an application that loads row-by-row and commits the changes afterward.... really no bulk methods? I was thinking that MySQL is a developed database but it is not if there are no bulk operations.
9 More Discussions You Might Find Interesting
1. Programming
:confused:
Hi!
I have created a Multhreaded Application in Pro*C (using pthreads) with about 5 Threads running simultaneously. The Application is basically to Update a Centralized Table in Oracle, which updates different rows in the Table (Each Thread updates different rows!). The... (16 Replies)
Discussion started by: shaik786
16 Replies
2. Programming
Hi all, I have a query about multithreading. What I would like to do is, at the start of my main update() function, start a couple of threads in parallel, once they are all complete carry on with my main update function.
void update() {
thread1->update(); // fluid solver
... (3 Replies)
Discussion started by: memoid
3 Replies
3. UNIX for Advanced & Expert Users
Hi,
Can you please give me a suitable reference to learn multithreading programming in C in UNIX?
Thanks (3 Replies)
Discussion started by: naan
3 Replies
4. Programming
Situation:
i have multiple pthread_create calls like this:
pthread_create(...., ThreadFunc1,.....);
pthread_create(...., ThreadFunc2,.....);
.
.
which i am using to create multiple threads.All the "ThreadFunc<i>" functions are actually calling same function "Receive" of a class using same... (3 Replies)
Discussion started by: Sastra
3 Replies
5. IP Networking
hello to all
i want to use multithreading to my UDP broadcast server client program. will anyone help me by proving C code. i am working in fedora. also my requirement is POSIX compliance.please help me..... (0 Replies)
Discussion started by: moti12
0 Replies
6. Programming
hello to all
i want to use multithreading to my UDP broadcast server client program. will anyone help me by proving C code. i am working in fedora. also my requirement is POSIX compliance.please help me..... (6 Replies)
Discussion started by: moti12
6 Replies
7. Programming
Dear all,
I am having a huge XML file, as below structure
<EMPLOYEE>
<RECORD id =aaa>
<Salary>99999</Salary>
<section>ssss</section>
</RECORD>
<RECORD id =bbb>
<Salary>77777</Salary>
<section>ssss</section>
</RECORD>
</EMPLOYEE>
This is a 50 GB file I want to read this file in... (9 Replies)
Discussion started by: arunkumar_mca
9 Replies
8. What is on Your Mind?
Hi Friends
any know how became a friend in this Android Programming Language (0 Replies)
Discussion started by: ljarun
0 Replies
9. Programming
I take this question of the The Linux Programming Interface: A Linux and Unix System Programming page 652 exercise 30.1
I want someone to explain the under line statement because it sounds complex to me couldn't understand anything
30-1 Modify the program (thread_incr.c) so that each loop in... (3 Replies)
Discussion started by: fwrlfo
3 Replies
LEARN ABOUT PHP
mysql_get_proto_info
MYSQL_GET_PROTO_INFO(3) 1 MYSQL_GET_PROTO_INFO(3)
mysql_get_proto_info - Get MySQL protocol info
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_get_proto_info(3)
int mysql_get_proto_info ([resource $link_identifier = NULL])
DESCRIPTION
Retrieves the MySQL protocol.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns the MySQL protocol on success or FALSE on failure.
Example #1
mysql_get_proto_info(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL protocol version: %s
", mysql_get_proto_info());
?>
The above example will output something similar to:
MySQL protocol version: 10
mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3).
PHP Documentation Group MYSQL_GET_PROTO_INFO(3)