Since the days in a week are not likely to change, why not have an indexed
column for each day? For example,
select id from courses where day_m = 1 and day_t = 0 and day_w = 1 and day_h
= 0 and day_f = 1;
Wouldn't this approach be more efficient than a full table scan with regular
expression
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]On Behalf Of Bret Ewin
Sent: Monday, January 21, 2002 12:03 PM
To: 'Russell King'
Subject: RE: Help with Database structure..
You may also want to break the URL into pieces (protocol, domain, path,
file) and index each piece
The first thing that comes to mind is that you're running the databases on
different hardware and operating systems. I know the Linux kernel had some
SMP performance issues not too long ago, prompting IBM to rewrite portions
of the kernel and improving performance by (I think) 16-20%. Also,
I need to know how to get a list of all the tables in a database. In Oracle
you could select OWNER, TABLE_NAME from ALL_TABLES to get a list of all
tables and their schemas. How does one do this in MySQL?
Thanks,
Bret
-
Before
You need something to limit the join. In theory a join with no limit will
generate the cartesian product (all possible permutations of all the rows)
of all joined tables. I've tried to demonstrate this below.
In general the use of DISTINCT is slow and should be avoided if possible.
Hope this
My system tends to generate large result sets, with the first page of
results being used and the rest thrown away. I expect this is typical in
other systems as well. I've noticed the JDBC driver retrieves the entire
result set before letting the application iterate over any results. I'm not
sure
Just making sure my post got processed. I replied to the join confirmation
after sending my first post. Sorry for the potential redundancy.
Bret
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 5:47 PM
To: [EMAIL PROTECTED]
Subject: returning
to
help. Any suggestions in this area?
Thanks,
Bret
-Original Message-
From: James Montebello [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 5:57 PM
To: Bret Ewin
Cc: [EMAIL PROTECTED]
Subject: Re: returning partial result set
If all you want is the first page, then simply use