RE: Concurrency Question

Quoting Marvin Wright [EMAIL PROTECTED]: Hi, It suggests below to bundle transactions into one commit, at what point does this become unecessary ? For example I have 2 threads each doing 12,000 inserts in 1 commit each. Would I really gain any performance if I did these 24,000 inserts in 1

Re: Mysql Limit

better engine than either MyISAM BDB and would be worth a look if designing your database from scratch for sure. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks Founder Huntington

Re: ORDER BY total of multiple columns?

as a column, and then reference it in the order by. -Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks Founder Huntington Beach, CA USA http://www.nodeworks.com1-714

Re: MYSQL performance question

. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051

Re: MYSQL performance question

tables, MySQL will save disk space, and provide you with much faster queries, but you have to be aware of the table locking issues if you are doing updates/inserts/deletes mixed with reads. --Josh _ Joshua Chamas

Re: Fastest query ?

index on date. When it comes down to it, doing your own benchmark of each method will always be better than what anyone might think. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link

Re: copy from one db's table to another

by the script mysqlhotcopy, and copy the raw data files at the OS level. You could also try this SQL: # uncomment if you are purging first # delete from dest.notes; insert into dest.notes select * from source.notes; --Josh _ Joshua

Re: my sql and memory--A confusing issue for a newbie

in Linux just fine on WinNT. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051

Re: key_reads and opened_tables.

your open_tables and opened_tables be in the same area if you haven't been running your database for very long ( 1 day ). --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring

Re: A question of performance?

= $dbh-selectall_arrayref(); for my $row ( @$rows ) { ... do something ... } --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http

Re: Running crash-me against remote M$ SQL Server

_ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051

Re: mysql over nfs on netapp filer

low. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051

Re: mySQL for Sun Intel

_ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - Before posting, please check: http

Re: need mysql sample to accomplish existing asp function

are however, that your friend's scripts are written with VBScript, as that is the primary dev language under IIS/ASP. I don't think there are alternatives to Chilisoft for VBScript ASP on Unix. --Josh _ Joshua Chamas