Thanx for reply...
Buddy I also did same things but in different way.
I added one column in a table as a datatype varchar, and then I had insert the value of "insertedda te column without Time" in new column.
And then I put indexing on that column and did some modification on the java code also. But when I saw the performance in my local box they are almost same not too much difference...
But Still I am searching...
coolbuddy
Last Activity: Feb 28 '10, 05:48 AM
Joined: Feb 26 '10
Location:
-
Joins takes more time... I already used that but that is also not useful...Leave a comment:
-
The Explain Plan of my query is as follows:-
Explain analyze Select * from tableA where liveid in (select id from tableB where vehicleid in (select id from tableC where registrationNum ber like '%0306')) and insertedDate>'2 010-02-25' and insertedDate<'2 010-02-26';
QUERY PLAN ...Leave a comment:
-
Hi Rski,
Thanks for reply.
I am using subquery, the query is:-
select * from tableA where liveid in (select id from tableB where vehicleid in (select id from tableC where registrationNum ber='MH4R2423') ) and inserteddate>'2 010-02-20' and inserteddate<'2 010-02-21'.
When I did indexing on inserteddate till 4-5 hours it work quite good. But when the table size is increase its takes too much time therefore...Leave a comment:
-
How we improve query execution of a bulky database..
Hi Friends,
I am working in Postgresql 8.3. In that I have one table A, this table contains number of attributes and we already put indexing on Id, liveId attributes. But this table also contains the insertedDate and one more and very important things is that in every seconds approx 30 hits occurred in this table.
When we are fetching the records from this table Its takes to much time. Yesterday I had put indexing on...
No activity results to display
Leave a comment: