Re: Is there any method to keep table in memory at startup

Andrew Dunstan wrote:

> 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
>