Vinay Jain wrote:
You mean that I should create a static table in C program itself and use it...if i am not wrong
Ya for the time being i am doing this thing but actually table is bigger (around 5000 rows with 6 columns)
bigger than what?
also this table is also created and destroyed in each indchar_lt call which is called many times in order by clause
uh ... maybe you need to look in your C manual about the effect of a "static" declaration. The object will be created once.
yup I know the effect of Static but this is also fact that when program terminates and restarts object will be created again...(not persistant)..
one thing strikes in my mind is that indchar_lt is function in shared object file indchar.so.....if this file is not unloaded during Order by call than this static defination can work for me..
Not sure but I think this file is loaded each time indchar_lt is called in order by clause...
one more thing i want it generalized so that I can include other indian languages also..without changing code..
If there is not any method to get results fast using database table i will have to opt this option only..
Not for what you want - you are pursuing a chimera, IMNSHO.
cheers
andrew regards
Vinay jain
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
