Is instant text search possible in big table with HTMLs?

I have a pretty big table with HTMLs (about 500K rows, average length of text is ~150K). It is required to make fast search (less than 1s) rows which match let say ‘%<meta name="twitter:app%’. First 10 results are enough.

Possible solution I have tired (on Postgres mainly):

  1. Full-text search: results look not relevant and may miss something (can not find a way to improve it).
  2. Trigram index (...USING GIN (t gin_trgm_ops)...) – a cool feature of PosgreSQL by the way. It worked fast on my synthetic tests, but when I applied to my HTMLs set – it worked minutes(!). I used explain anaylze, what showed me that index is used (what is nice), but than Postgres recheck what matched by index and this is quite slow, because it needs to make linear text search in large texts, one by one. On synthetic tests it worked because my texts were relatively small.
  3. Also I tied Elastic (I used ‘wildcard field type’, Elastic use trigram index as well in that case), but performance was even worse that in Postgres case.

I still believe that it possible, but how?

Change Text – Inside A button, inside a Canvas, inside a GameObject: Access all the texts inside of hierchy?

 //.... Gameobject tile; int count = 1; float posX = 0; float posY = 0; ....//  GameObject blueTile = (GameObject)Instantiate(Resources.Load("block_blue")); tile = (GameObject)Instantiate(blueTile, transform);  for loop {    ...    ...    tile.GetComponent().GetComponentInChildren().text = count.ToString();    tile.transform.position = new Vector2((float)posX, (float)posY);    count++; }  

enter image description here enter image description here

As you can see by the image. My line of thinking goes like this; I used to create Flash/AS3 Applications and Games. I have used a number of API’s and they usually have a lot in common. Unix, however, is very different and I may have not grasped the key concepts.

I want to access my PreFab, named in Assets/Resources (the root path)

All I wan to do is set up a row and columns of a box with a number inside of it.

Before you go and ask, why the complicated mix of Objects? Well, Adobe had MovieClip and use of layers and also use of a timeline. Unix doesn’t seem to have this in setting up a Scene (the Stage in Flash).

So, I set up a block that looks like this (right of main image 66): It’s a Canvas, to hold a Button, the button has a text. To move the Canvas, I put the Canvas inside a GameObject. This, to me, is like a MovieClip in Flash API.

**GameObject > ButtonLight, Button > TextBlack, Text**

I need to access TextBlack and also Text. Pretty easy right? I’ve been at this for 4 days, many many hours.

EDIT: It seems that it is working, somewhat.
Looking at the reference photo and the Hierarchy reference, it looks like the blackText behind the blueText is changing as expected. But I cannot access the top BlueText. The Blue Text is also a child of type Text, but it’s a second (layer?) copy of the text inside of the Button. So, it’s getting the first Child Text, but how to access the second Text?

Htaccess Using RewriteMap with a text file

I can’t use link with * Example – http://localhost/photo_gallery/public/show_c.html/color-1* The requested URL was not found on this server. The others work’s color-3, wood, etc.

  1. generated map – map.txt

    title   id color-1* 1 color-1** 2 color-3 3 wood 4 color777 5 color-test 6 
  2. htaccess

    RewriteRule ^show_c.html/([-\w]+)$   show_c.php?cat=$  {catcolors:$  1} [L] 
  3. httpd.conf

    RewriteMap catcolors "txt:C:\wamp\www\photo_gallery\public\maps\map.txt" 

My question. Why the link with * cannot be used.

Placing text over a rectangle using graphics

I need to add some text to rectangles that I am using as a scale bar. I want the text right above the rectangle and centered. Here’s my code:

Show[{Graphics[{Red, Rectangle[{0, 0}, {45, 15}]}, ImageSize -> 48],    Graphics[Text[Style["TEXT", 12, "TR", Black, Bold]]]}] 

enter image description here

Desired result:

enter image description here

How can I do that?

Edit: Ideally it should also work if the text is longer than the scale bar, like so:

Graphics[{Red, Rectangle[{0, 0}, {19, 15}],    Text[Style["TEXT", 14, "TR", Black, Bold], {10, 22}]},   ImageSize -> 19] 

The bar crops some of the text: enter image description here

How to see the original text of the the function that has been wrapped by “DBMS_DDL.WRAP”

As I’m new to Oracle PL-SQL,I’m trying to be familiar with DBMS_DDL package and I used it to hide my source code,below you can see the example I’m working on:

Declare   v_string varchar2(32676); begin      v_string := 'create or replace function get_os_user                   return varchar2 ' || ' is  ' || ' begin ' ||               ' return (sys_context(''userenv'',''os_user''));' || ' end; ';      execute immediate sys.dbms_ddl.wrap(v_string); end; 

The function get_os_user is created in the function section and In the view mode , I see the non readable hex format of the original function.Now my question is how I can see the original format of the function? The way the book from which I read about the package just said this:

The original text can be viewed in DBA/ALL/USER_SOURCE 

Where is DBA/ALL/USER_SOURCE? Are there other ways to see the original format of wrapped functions and procedures?

Which is the correct rules text for Darkvision?

Reading the PHB sections on races, e.g. Dwarf p. 20, it says …

Darkvision. Accustomed to life underground, you have superior vision in dark and dim conditions. You can see in dim light within 60 feet of you as if it were bright light, and in darkness as if it were dim light. You can’t discern color in darkness, only shades of gray.

But at PHB p.184 it doesn’t mention dim lighting conditions, only what Darkvision does in full darkness. It says …

Darkvision: Many creatures in the worlds of D&D, especially those that dwell underground, have darkvision. Within a specified range, a creature with darkvision can see in darkness as if the darkness were dim light, so areas of darkness are only lightly obscured as far as that creature is concerned. However, the creature can’t discern color in darkness, only shades of gray.

So the various character races can see in darkness as if it were dim, and in dim light as if it were bright, whereas "creatures" can only see in darkness as if it were dim?