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 inser

Re: need mysql sample to accomplish existing asp function

to the mod_perl environment on Apache. Other favorites there include HTML::Embperl, HTML::Mason & AxKit. Chances 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 VB

Re: mySQL for Sun Intel

x86 2.6. -- Josh _________ Joshua Chamas Chamas Enterprises Inc. NodeWorks >> free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - Before posting

Re: mysql over nfs on netapp filer

d the SQL volume was pretty low. --Josh _________ Joshua Chamas Chamas Enterprises Inc. NodeWorks >> free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com

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

mind you, but heard it to be true. -- Josh _________ Joshua Chamas Chamas Enterprises Inc. NodeWorks >> free web link monitoring Huntington Beach, CA USA http

Re: Mysql Limit

en released for almost a year but is a much better engine than either MyISAM & BDB and would be worth a look if designing your database from scratch for sure. --Josh _____ Joshua Chamas

Re: ORDER BY total of multiple columns?

otal desc The trick is to alias the equation above as a column, and then reference it in the order by. -Josh _________ Joshua Chamas Chamas Enterprises Inc. NodeWorks Founder Huntin

Re: A question of performance?

sets to: while(my $row = $sth->fetchrow_arrayref) { ... do something to $row, then output, move on ... } than it is to: my $rows = $dbh->selectall_arrayref(); for my $row ( @$rows ) { ... do something ... } --Josh _ Joshua Cham

Re: MYSQL performance question

w index. Comparing Oracle vs. MySQL myisam 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 _______

Re: Fastest query ?

DESC LIMIT 1 # very elegant If not, I'd use explain on the select to see whether it's picking up your 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 __

Re: copy from one db's table to another

insert into dest.notes select * from source.notes; --Josh _________ Joshua Chamas Chamas Enterprises Inc. NodeWorks >> free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051

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

Rather, it lets your OS cache the data file, which works very well in Linux & just fine on WinNT. --Josh _________ Joshua Chamas Chamas Enterprises Inc. NodeWorks >> free web link monitoring Huntingto

Re: key_reads and opened_tables.

ch might be a good thing anyway now and then. You probably should have 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

Re: MYSQL performance question

> using myISAM. Yes. This is how I use MySQL too. --Josh _________ Joshua Chamas Chamas Enterprises Inc. NodeWorks >> free web link monitoring Huntington Beach, CA USA http://ww