Dear Friends,
I have a database with approximately 10 tables with about 1 lakh records
each in 3 tables, I need to know that on what factors does the speed of
mysql depends,
1)Does a table having records effects the speed of data fetch of another
table in the same database.
2)Whats
Hello,
i have a question.
I will have to set up a MySQL Database which will have a hughe amount of
entries in a table. I did some tests and my select statements would need lot
of time.
I just wanna ask if there are some generally ways to speed up performance of
mysql statements?
thanx in
PROTECTED]
Subject: speed up MySQL Selections
Hello,
i have a question.
I will have to set up a MySQL Database which will have a hughe amount of
entries in a table. I did some tests and my select statements would need lot
of time.
I just wanna ask if there are some generally ways to speed up
Hello,
i have a question.
Don't we all :-)
I will have to set up a MySQL Database which will have a hughe amount of
entries in a table. I did some tests and my select statements
would need lot
of time.
I just wanna ask if there are some generally ways to speed up
performance of
Second - probably it's a bug. I cannot say much as the code used by this
query was removed from MySQL source tree. It was replaced by completely
new boolean search engine written from scratch. Unfortunately it was
done several days _after_ 4.0.0 release.
Wait for 4.0.1 - it should be out in
Sergei Golubchik wrote:
Hi!
I didn't test it yet.
The one thing I can say just now that unlike natural language search
code (as exists in MySQL in 3.23) it need not to build the complete list
of matched documents in memory in advance. It means that with LIMIT it
should be MUCH
On Thu, 15 Nov 2001, Gabor Penoff wrote:
can you tell me an estimated speed about filling 100 records with
mysql insert by using the C api?
Last insert job I ran did c. 400 inserts per second. This is real
(wall) time and some computations were involved.
(Dont go running fetching a
On Thu, 15 Nov 2001, Jonothan Farr wrote:
There's no way to know that without knowing the schema of the
table you're inserting into. How you index it is going to be the
biggest factor there.
just a plain file with 2 columns - one of them is a decimal field -
taht's all.
cu,
fns
-[
Subject: speed of mysql insert through C api
Hi folks,
can you tell me an estimated speed about filling 100 records with
mysql insert by using the C api?
I know the question sounds silly - all I have now is a suspicion that
I make something wrong (I mean the insert seems to be quite slow here
On Sat, Nov 03, 2001 at 12:07:03AM +, Manjeet Singh wrote:
Hi Group,
I am new to mysql, and would like you all to give some time in
resolving my trouble. I am stuck up with a problem of designing
stores database for a big company.The company is located in
different places and wants
Hi Group,
I am new to mysql, and would like you all to give some time
in resolving my trouble. I am stuck up with a problem of
designing stores database for a big company.The company is
located in different places and wants web-based insertion,
retrival and maintaining of data and records in the
I'm currently using a 166 UNIX machine for a dedicated MySQL database,
and I'm interested in knowing what kind of speed I should be expecting
from it. I ask because right now it's at a point of being unusable even
for development on some of the larger queries.
I compiled MySQL 3.23.37 myself
On Fri, Jun 15, 2001 at 05:51:11PM -0600, Chris Cameron wrote:
I compiled MySQL 3.23.37 myself with -O6's -march-i586 and various
./configure options I don't remeber. The database I'm using has 3
tables of about 9 thousand entries, un-indexed decimal(5,8)'s, and a
few tinytext's. There are
Hi.
Do you have an index SIC? If so, I don't know any reason which would
explain such a slow server for such a simple query (on a table with
only 9.000 records), no matter what the configuration is.
If SIC is one of those unidexed decimals, the speed may be expected,
depending on the database
hi,all
i have a strange question.
I use FreeBSD4.2-RELEASE + mysql-3.23.32
Dual PIII667+ 768MB RAM
I have a table like this
CREATE TABLE ABC (
A int(10) unsigned DEFAULT '0' NOT NULL,
B int(10) unsigned DEFAULT '0' NOT NULL,
C0 bigint(20) unsigned DEFAULT '0' NOT NULL,
C1 bigint(20)
a couple of the fields indexed
jason
- Original Message -
From: "chchen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 10, 2001 6:35 PM
Subject: Speed of mysql
hi,all
i have a strange question.
I use FreeBSD4.2-RELEASE + mysql-3.23.32
Dual PIII667+ 768MB R
16 matches
Mail list logo